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: 
Not applicable

fixed number with 2 digits after the point

Hi,

I will be glad to get some help.

How can I convert the number to format of xxxxxx.xx (2 digits after the point) ?

I got long scientifc numbers with E sign and I want to convert the field to the format which descibed above.

Thanks in advance,

Nimrod

2 Replies
Not applicable
Author

Use the function num( X , '0.00')

or maybe

num( X, '#,##0.##')

to make it even more readable. [Where X is your field name]

Not applicable
Author

Thanks.