Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculation issue for 14 digits

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'))

   

6324.876543256786067.5463267854384
6321.65432876548703421.6578765432100
646.53087202227303489.2042033286500
745.5432167654321876.4567890765430
754.6543217867543654.6754321876540
100.19753855218601531.1322212642000
3 Replies
Anil_Babu_Samineni

Try

Num(sum())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
MarcoWedel

maybe helpful:

Evaluate() Function

regards

Marco

Not applicable
Author

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