Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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