It is very easy to round numbers in Alteryx. Here’s a short tutorial on how to do it in simple steps:
- Inside Alteryx's workflow designer, head over to the left-side panel and find 'Formula'. Drag this tool onto the canvas and connect it to the Input Data tool or other sources.
- Following that, go to the right-hand panel and make all the necessary configurations. To get started, enter a unique name into the Output Column field and then choose 'Integer' as the Field type.
- Head over to the Formula field and type 'Round'. Select it from the suggested results afterwards.
- Following that, replace X with '[' and then choose the field that contains the numbers you wish to round.
- Subsequently, replace MULT with your preferred factor.
- Finally, the numbers in the selected field will be rounded according to your input.
.gif)
