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