How to Convert a Number From Negative to Positive
Doing a calculation today to see how many hours a support case is open, using the following sugarlogic formula:
I get a negative value returned. Whilst accurate, the client is wanting to see this as a positive integer, not a negative integer.
So the question I had was “How do I convert a negative number to a positive number?”
It’s quite simple really, you wrap it in the
abs() function. This will return the absolute value of a number.
Thus the resulting sugarlogic formula is: