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