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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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