Hot to use the num() function to round up

[#1]

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,

[#2]

Hey Colin,

If I use that script, I get 35756,4 😕

[#3]

Hey Saurabh,

If I use that script, I get 35756,4.

Thanks, Peter

[#4]

Hey Marco,

If I use the Ceil()-function I get 35756,4 😕

[Anonymous]

Hi,

try this

=Round(Sum(budget),0.1)

With Regards,

Arryan

[PrashantSangle]

Hi,

just one question . is your thousand seperator or decimal seperator.

Regards

[#7]

Hey swuehl,

Thanks for the suggestions.

If I use =num(35768/1000,'#.0 k','.',',') I get 35756.4 k

and

If I use =num(35768/1000,'#.0','.',',') I get 35756.0

Peter

[#8]

Hi

. is my thousand seperator.

Regards

[qlikmsg4u]

Hi,

try this

ceil(num(sum(budget)/1000,'#.##0',',','.'),0.1)

[prabhas277]

Hi,

try it

=num(round(35.765,0.1))

[#11]

Hi K N,

Good suggestion, still got 35756,4 though.