Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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