Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
17 - Castor

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

 

binuacs_0-1674665697121.png

 

binuacs
17 - Castor

@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