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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exponential Value into Number

Hi All,

In one of the report ,One of My Key figure field returning values like this -2.8189506969926e-008 but when I am using in straight table or Pivot table it is showing as -0 amount but i want key figure should be display like -2.8 in the table . I am using number format in Number tab  fixed upto one decimal.

Please suggest me any Idea to fix this Issue. It is Urgent.

Regards

Deepak

2 Replies
Frank_Hartmann
Master II
Master II

-2.8189506969926e-008*100000000

Frank_Hartmann
Master II
Master II

or

num(-2.8189506969926e-008,'#.##,###############')*100000000