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.
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?
Solved! Go to Solution.
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...
Thanks Calvin. Now I'll check the knowledge base first before I ask here!
User | Count |
---|---|
106 | |
82 | |
72 | |
54 | |
40 |