Rounding up decimals

[sislam11]

Hi all,

Would appreciate some help on rounding up decimals in Alteryx. I have tried to use the CEIL function however this only rounds up integer.

Some examples of desired output:

0.7883223 --> 0.7884

0.989132 --> 0.9892

Essentially I would like to round up to the fourth decimal places in all cases however the CEIL function does not provide any options to specify the number of decimal places. Are there any work arounds?

Many thanks in advance!

[Luke_C · Accepted solution]

Hi @sislam11 

Give this a try:

ceil([Field1]*10000)/10000

[Qiu]

@sislam11 
FYI, this thread discussed in detail the CEIL, FLOOR, ROUNDUP and ROUNDDOWN.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/RoundUp/td-p/823666

[allwynthomas24 · Accepted solution]

Hey @sislam11,

Just check the attached workflow and confirm whether this works out for you.

Thanks & Regards.