@ABS
The @ABS calculation function for Essbase returns an absolute value.
This function 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)
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