Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Rounding up decimals

sislam11
5 - Atom

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!

3 REPLIES 3
Luke_C
16 - Nebula

Hi @sislam11 

 

Give this a try:

ceil([Field1]*10000)/10000

Luke_C_0-1648655280146.png

 

 

Qiu
19 - Altair
19 - Altair

@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
11 - Bolide

Hey @sislam11,

 

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

 

Thanks & Regards.

Labels