Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Digvijay_Singh

Can we show somehow these very high numbers in standard format

Hello,

Let me know if there is any way to change these very high/low numbers in normal format like '#,##0.00' format. I have used Money(Value,'#,##0.00') in the expressions. Thanks in advance for the help!

Capture.PNG

13 Replies
YoussefBelloum
Champion
Champion

or maybe divide this measure by 1 billion.. and put a symbol of billion (B) on the number section ?

Digvijay_Singh
Author

I think you are right, Needs to build the larger units dynamically in the expressions.

oliveira1903
Contributor III
Contributor III

Hello, there. =]

I have a simmilar problem. Is there a way to convert into a numeric field like that '$#.##0,00' (money)? 

My field is showing this 1,334244462e+15 insted of $1.334.244.462.000.000. Is it possible?

Thanks a lot.

 

 

 

oliveira1903
Contributor III
Contributor III

Hello, there. =] @jonathandienst 

I have a simmilar problem. Is there a way to convert into a numeric field like that '$#.##0,00' (money)? 

My field is showing this 1,334244462e+15 insted of $1.334.244.462.000.000. Is it possible?