essbase @ABS

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.

Syntax

@ABS (expression)
Parameter Description
expression Member name or mathematical expression that generates a numeric value.

Example

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.

Variance=@ABS(Actual-Budget);

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

  • @INT
  • @REMAINDER
  • @ROUND
  • @TRUNCATE