Alteryx Designer Desktop Discussions

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

Is there a way to round up to 2 decimals no matter what the 3rd+ decimal is?

CherieACI
8 - Asteroid

I have data in a field that sometimes has more than 2 decimals and when it does I need it to round up every time. Example: 150.3123 I need to round up to 150.32, so even though the 3rd decimal isn't above 5 I still need it to round up. (If there are more than 2 decimals then I need to round up every time) Can Alteryx do that? 

 

Thank you in advance,

Cherie

4 REPLIES 4
MarqueeCrew
20 - Arcturus
20 - Arcturus

@CherieACI ,

 

 how about:

 

... i like @atcodedog05 answer better ..

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
atcodedog05
22 - Nova
22 - Nova

Hi @CherieACI 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1645473868598.png

 

Hope this helps : )

 

CherieACI
8 - Asteroid

This solution worked! Thank you very much! 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @CherieACI 

Cheers and have a nice day!

Labels