Expression Model: ABSOLUTE VALUE(NUM)

This tip covers the instruction model: ABSOLUTE VALUE(NUM). This model returns the positive (or absolute) value of a number variable.  In some accounting formulas, the result of the formula will be a negative number.  You may want to not the value as a negative, but still be able to treat and format the number based on its positive value

What are the elements?

  • ABSOLUTE VALUE: The function

     

  • NUM: A number value, positive or negative

How do you use it?

Use it in a fillpoint or computation for a variable entered in the system

ABSOLUTE VALUE(Profits NU)

Use it to test the result of a calculation

ABSOLUTE VALUE(Gross Revenue NUExpenses NU)