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?
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.
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
