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