Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1140
Best Way to Perform Math Calculations
posted

Hi,

I am using a grid which is bound to a dataset and I am using some unbound columns where I am doing some math calculations based on the values entered by the user.

For getting the values from the cell i am using something like

 TodateQty = CType(e.Cell.Row.Cells("TodateQty").GetText(Infragistics.Win.UltraWinMaskedEdit.MaskMode.IncludeBoth), Double)

within the cell change event and performing the calculations and updating the other columns.

But even though I made it a double or decimal if the calculation is 152.14 - 150.00 it shows be 2.00 instead of 2.14. How to get it accurate.

Also, If there is any best way suggest me for calculations.

also please provide the link if there is some example in KB.

 

Thanks

 

 

  • 469350
    Offline posted

    Hi,

    I'm not sure I understand. If you are doing subtraction and getting an incorrect result, then something is seriously wrong on your machine that has nothing to do with the grid. :)

    Are you saying that you are getting the correct result, but that the grid is formatting it incorrectly?What do you mean by "it shows 2.00?" What shows it? What are you doing with the result of the calculation you are performing?

    Or are you saying that you are getting the wrong value form the grid cell?