Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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