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