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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hot to use the num() function to round up

Hey,

I'm trying to round up a number in a text box using the num() function.

I'm currently using the script: num(sum(budget),'#.##0',',','.') and getting the result: 35.756.

How should the script be if I want the result to be: 35.8?


Thanks,

23 Replies
antoniotiman
Master III
Master III

Num(35768/1000,'#0.0','.',',')  ->  35.8

Not applicable
Author

Hi,

That gives me 35765.

Regards,

Not applicable
Author

Nope, my bad, it worked! Thanks

qlikmsg4u
Specialist
Specialist

but when i tried it i got it as you expectedCapture1.PNGCapture2.PNG