Replace "Minus sign" in a calculated column

[AbbasG]

Hello All,

I have a calculated column, calculating the overdue days based on customers' payment terms. I need to get rid of the Minus sign from the column. Please help how can I do that.

[NickolajJessen · Accepted solution]

Measure = Sum(calculatedColumn)* -1 

And replace that

[Reenu12]

how to remove minus from some of value from my data. Because it showing -minus thats why data not come in 30-60 days .how I can fix that.

[AbbasG]

@NickolajJessen It worked 🙂 Thank you so much.

@tamerj1 Thank you for your effort too 🙂

[tamerj1]

@AbbasG 

The ABS function makes sure you have allways positive result but if multiply by -1 then if the number is originally positive it will become negative. Just to note. 

[tamerj1]

Hi @AbbasG 

you can use ABS function that returns the absolute value