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 ( numeric_value_expression )

Example

The following example is based on the Demo Basic database. The absolute value is taken in case Variance is a negative number. Absolute Variance is always a non-negative number.

The following query:

WITH MEMBER
 [Scenario].[Absolute Variance]
AS
 'Abs([Scenario].[Actual] - [Scenario].[Budget])'
SELECT
 { [Year].[Qtr1].children }
ON COLUMNS,
 { [Scenario].children, [Scenario].[Absolute Variance] }
ON ROWS
FROM 
 Demo.Basic
WHERE
 ([Accounts].[Sales], [Product].[VCR], [Market].[San_Francisco])

returns the grid: