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:
hoursUntil($date_entered)
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:
abs(hoursUntil($date_entered))
Written on February 20, 2020