Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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