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:
- 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.
- 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.
- Subsequently, go to the Formula field and then type 'Round'. Select it from the suggested results.
- Replace X with '[' and then choose the field that contains the data you want to edit.
- Next, replace Mult with '0.01' to specify your desired multiplier, which is two decimal places.
- Finally, the data from the selected field in your Alteryx workflow will be rounded to 2 decimal places.
