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

 

2 REPLIES 2
binuacs
20 - Arcturus

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

 

binuacs_0-1674665697121.png

 

binuacs
20 - Arcturus

@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

 

Labels