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

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