calculation issue when the length of number is too long

[kongshuai]

Hi guys,

I met a problem that is when the length of number is too long, then the result will be incorrect. like 41737378308000000-41739549592356000. in excel the result is -2171284356344, but in qlikview it is -2171284356000. Have you guys met this issue before? look forward your answer, great thanks.

[kaushiknsolanki]

Hi,

Check this link, this should help.

https://community.qlik.com/t5/QlikView-Scripting/Number-too-large-to-parse-as-number/td-p/281527

Regards,

Kaushik Solanki