Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am facing the calculation issue after decimal for 14 digits, QV always shows incorrect result . kindly any one provide the solution. Kindly find sample.
I am using num function after sum for calculation and ever after I remove num also values are not matching.
sum(num(field name,'###.##############'))
or
Sum(num(Fieldname,'###.00000000000000'))
6 | 324.8765432567860 | 67.5463267854384 |
6 | 321.6543287654870 | 3421.6578765432100 |
646.5308720222730 | 3489.2042033286500 | |
7 | 45.5432167654321 | 876.4567890765430 |
7 | 54.6543217867543 | 654.6754321876540 |
100.1975385521860 | 1531.1322212642000 |
Try
Num(sum())
Marco
I tried with this function, I am facing the problem while I am storing at the QVD. 0 values are getting truncated automatically while storing at the QVD file.
we are summing the value at the QV end and storing those value at the QVD file.
Regards
Srini