Rounding up decimals

Question

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 Answer

Hi @sislam11

Give this a try:

ceil([Field1]*10000)/10000

allwynthomas24 · Accepted Answer

Hey @sislam11,

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

Thanks & Regards.