Change logic in Round() function

[Pawel_Paleczny]

Instead of current logic standing behind Round function ([variable1]/[variable2], mult) more intuitive will be approach known for example from SQL where the second operator represents number of decimal places, i.e. [variable]=23,4567 with new logic - Round([variable], 2) = 23,46.

[cgoodman3]

This would make it more consistent with the round function in Excel where the second parameter is the number of decimal places you want to round it to. 

https://www.causal.app/formulae/round-excel

and I’d imagine most Alteryx users either come from Excel or SQL backgrounds therefore it will improve similarity between the tool tools.

[Pawel_Paleczny]

@cgoodman3 I believe that generally Excel and SQL using similar concept for rounding and implementation this logic into Alteryx might be really beneficial, especially for new users (as you mentioned) probably with SQL/Excel background.

[NicoleJ]

By having a multiple as the parameter instead of decimal places, the current Round function actually provides much greater rounding flexibility than Excel - for example, when you want to round to the nearest multiple of something like 5 or 0.25, not just limiting to rounding to 0.01 or 0.0001. We do not have plans to make any modifications to this function (not to mention all the existing workflows it would break 😬 ) HOWEVER if you feel there are things we could do to make the descriptions or help documentation more clear on how to use this function, please do let us know!!