Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula question - rounding to two decimal places

Alteryx_1505
6 - Meteoroid

I have a workflow where I have a balance column. In the original file the data type is currently a v_string data type. In my filter tool, I'm changing it to the Double data type. 

 

Alteryx_1505_0-1758844823422.png 

 

Alteryx_1505_2-1758844894530.png

 

In my formula tool, I'm doing a round formula to round the balance column to 2 decimal places. Instead of rounding to 2 decimal places, it's being rounded to the next full number. Can someone explain to me how or what I'm doing wrong? Do I have the wrong data type selected? 

 

Alteryx_1505_3-1758845108027.png

 

 

2 REPLIES 2
caltang
17 - Castor
17 - Castor

0.01 for your decimal place rounding. Refer here please https://knowledge.alteryx.com/index/s/article/How-To-Round-Numeric-Values-with-the-Formula-Tool-1583...

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx_1505
6 - Meteoroid

Thanks Calvin. Now I'll check the knowledge base first before I ask here!

Labels
Top Solution Authors