Forum Discussion
Len
10 years agoRegular Visitor
How to convert negative numbers into positive numbers
Hi all, Apologies in advance if this has been answered before. As the subject suggests; How can I convert negative numbers into positive numbers? Thanks
Greg_Deckler
Community Champion
10 years agoLen - You might have to wrap it in an IF statement if you want to preserve already positive numbers.
You could also use the ABS function (absolute value)
You cold also multiple by -1, "[Column] * -1"
With ABS you could get rid of negative numbers while not impacting the positive numbers.