Hello,
I am new to Alteryx so any assistance is appreciated. I need to do a 1:1 rounding from Excel. What is the best way to ensure that the numbers I enter into Alteryx is going to give me the exact total that I get from Excel?
Thanks in advance.
Tom
Solved! Go to Solution.
Hey @tmarlow2060,
You can use the Round() function, which will round according to classic mathematical rounding rules (e.g. Round(4.565,0.01) will result in 4.57) See https://help.alteryx.com/20231/designer/math-functions (ROUND) for more details.
There are also other functions like this, e.g. CEIL or FLOOR for rounding up/down.