Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
43918084
Creator II
Creator II

Conversion of Exponential Notation to Decimal numbers

 

 

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

Labels (1)
1 Reply