Hello Everyone,
We allow users to enter the amounts in the editable grid using the textbox component. (saving these values in the CDT decimal field)
And displaying the total amount and validating the total column against other values.
Values entered are :
430603.1013871.55117011.6523402.33
Would like to know why the sum function is not giving the value with the correct precision.
And also to calculate the sum with correct precision, do we need to use Fixed?
Discussion posts and replies are publicly visible
Computers represent decimal number with a limited precision. In your case, trying to convert between text and decimal multiple times does not help either.
Fixed should only be used to display a value to the user as it returns a string.