Conversion of Exponential Notation to Decimal numbers

43918084 — Tue, 30 Nov 2021 16:25:32 GMT

I have a field that contains both numeric and text. For some numeric value, the number is 580886158980001000000.

But Qliksense returns 5.8088615898e+20.

I have tried to use Num(Replace("Arr Lcl Num Ath", ',', '.'), '(dec)') as ALN

But the result return "-"

Hope I can have some expert guidance

topic Conversion of Exponential Notation to Decimal numbers in App Development