Rounding 1:1 from Excel

[tmarlow2060]

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

[FrederikE · Accepted 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.