How to change the negative value to positive value

[vsalver]

Can someone please help me with the formula to change the negative value to positive and in the same column I have the positive value as well and it shouldn't be changed.

Amt

   5

-15

  25

-35

[Claje · Accepted solution]

Hi,

The ABS() function in the Formula tool will do this by getting the absolute value for each of these.

ABS([Amt])

Should do it.

[vsalver]

@Claje thank you so much, it worked

[joshikalyani]

But in my case it is showing error

[RBrines]

You would want to make sure your incoming data type is numeric. The error there looks like you have a string type instead. 

[aatalai]

@RBrines you could also do it with this formula (to avoid needing a select tool

abs(tonumber([Field]))