Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Dividing Numbers

Ahasan13
7 - Meteor

Hi all, 

 

I am trying to divide the numbers in the "Amount" and the "Balance" column by 1000. I want to do know how would I do this in the same column and/or create a new column? 

 

Ahasan13_0-1674665507403.png

 

3 REPLIES 3
binuacs
21 - Polaris

@Ahasan13 One way of doing this with the Multi-Field formula

 

binuacs_0-1674665697121.png

 

binuacs
21 - Polaris

@Ahasan13 IF you wan to the output in new column you can use the same multifield tool with some update like below

binuacs_0-1674665883032.png

 

nathanedwards
5 - Atom

You can also simple formula tool:

Output Column = Amount

formula will be:

[Amount]/1000

Data Type = double

then do a comparable formula for your balance field.

Labels
Top Solution Authors