Returns the absolute value of expression. The absolute value of a number is that number less its sign. A negative number becomes positive, while a positive number remains positive.


@ABS (expression)


Member name or mathematical expression that generates a numeric value.


The following example is based on the Demo Basic database. In this example, Variance needs to be presented as a positive number. The @ABS function is used because otherwise some combinations of Actual - Budget would return negative values.


This example produces the following report:

Sales                 VCR      San_Francisco 
                      Jan      Feb      Mar 
                      ===      ===      ===                                       
Actual              1,323    1,290    1,234 
Budget              1,200    1,100    1,100 
Variance              123      190      134

See Also