Multiply all fields in the column by a negative value

[JamesG2806]

Hi,

I want to Multiply all fields in the column by a negative value so if I have data similar to the below

Account                 Amount

Can                        -23019

UPS                       -2019

PBS                       -791.21

So I want to multiply all values under amount column by -1 to make them positive values. 

[Ladarthure · Accepted solution]

Hi @JamesG2806,

you can use a formula to do so, just have a formula like this one [Amount]*-1 or abs([Amount])

[joshuaburkhow]

Yep, easiest way is use a formula tool to do that. Just take that field and multiple by -1