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