Rounding half up to 2 decimal places

NiallLennon

Hi all

Just wondering if anyone has any advice on how to round half up to 2 decimal places within Alteryx?

Tried using the usual tools (Select etc) and the Round formula function but not getting the results I'm hoping for

Is there a tool/formula you would use to try and do the same thing?

Many thanks

ChrisTX

Check out the detailed explanation of the Round function in this recent post:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Round-rounds-up-if-the-next-digit-is-5-or-higher-Otherwise/td-p/1301158

Chris