Dividing Numbers

[Ahasan13]

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? 

[binuacs · Accepted solution]

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

[binuacs · Accepted solution]

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

[nathanedwards]

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.