topic Re: calculation issue for 14 digits in QlikView

calculation issue for 14 digits

Wed, 25 Nov 2020 16:16:04 GMT

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,'###.##############'))

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

Re: calculation issue for 14 digits

Anil_Babu_Samineni — Fri, 14 Oct 2016 16:31:31 GMT

Try

Num(sum())

Re: calculation issue for 14 digits

MarcoWedel — Sat, 15 Oct 2016 00:09:15 GMT

maybe helpful:

Evaluate() Function

regards

Marco

Re: calculation issue for 14 digits

Mon, 17 Oct 2016 04:00:06 GMT

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