It is very easy to divide 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 it onto the canvas and connect it to the Input Data tool or other sources.
- Following that, go to the right-hand panel and configure the Formula tool. To get started, type a unique name into the Output Column field and then set its type according to your preferences.
- Type '[' afterwards, then select the field that contains the values you wish to use as the dividend.
- Subsequently, type 'Division' and then select it from the suggested results.
- Type '[' once again and select the other field that contains the values you wish to use as the divisor.
- Finally, the numbers from the selected fields will be divided accordingly.
.gif)
