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 One way of doing this with the Multi-Field formula
@Ahasan13 IF you wan to the output in new column you can use the same multifield tool with some update like below
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.
