Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Rounding Issue?

jonnyrask
8 - Asteroid

If you look at the screenshots I am using this formula to round a value and it doesn't round as expected. I want it to round to: .23 not .24

 

How can I get around this?

1 REPLY 1
MichaelLaRose
10 - Fireball

Hi @jonnyrask 

 

The round function you created rounds to the closest multiple of .02.

 

To round to .23 you just need to change your increment to .01.

 

Best,

Michael

Labels