Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Number formate

Hi..

my number is 0.0008945 i want to to display only 0.006 formate means after point i want to display only 3 digits.

please help me..

Regards,

Chandini.g

3 Replies
senpradip007
Specialist III
Specialist III

Try like:

Num([Your Number], '#.###')

or

round([Your Number], 0.001)

alexandros17
Partner - Champion III
Partner - Champion III

use

ceil(0.0008945, 0.0001)

Anonymous
Not applicable
Author

Hi..

Thanks for reply...

Regards,

Chandini