Converting numbers from negative to positive

[maurcoll]

Hi

I have a column in my table which is a decimal number. Some of the values are positive numbers and some are negative. I want to be able to convert the negative numbers to a positive.
I have tried using Number.Abs and that doesnt work, is there a way to change the negatives. 

Total

1 13 -20 10 -8 25

Thank you for your help

[Royel · Accepted solution]

Hi @maurcoll  use only ABS() it should work  

In here i have created a calculated column, Abs Value = ABS('Table'[Total])

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

[srlabhe · Accepted solution]

This should be relatively easy using ABS() as susggested Royel below 

[Royel · Accepted solution]

Hi @maurcoll  use only ABS() it should work  

In here i have created a calculated column, Abs Value = ABS('Table'[Total])

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!