How to Round Numbers to 2 Decimal Places in Alteryx

‍

It is very easy to round numbers to 2 decimal places in Alteryx. Here’s a short guide on how to do it in simple steps:

1. Inside Alteryx's workflow designer, head over to the left-hand panel and find 'Formula'. Drag it onto the canvas and connect it to the Input Data tool or other sources.
2. After that, go to the right-hand panel and configure the selected tool. To get started, enter your preferred Output Column name into the provided field and specify the Field Type you wish to set.
3. Subsequently, go to the Formula field and then type 'Round'. Select it from the suggested results.
4. Replace X with '[' and then choose the field that contains the data you want to edit.
5. Next, replace Mult with '0.01' to specify your desired multiplier, which is two decimal places.
6. Finally, the data from the selected field in your Alteryx workflow will be rounded to 2 decimal places.