- (Negative) (MDX)
Performs a unary operation that returns the negative value of a numeric expression.
Syntax
-Numeric_Expression
Parameters
- Numeric_Expression
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.
Return Value
A negative value that has the data type of the specified parameter.
Examples
The following example demonstrates the use of this operator.
-- This member creates a negative version of the
-- Reseller Freight Cost.
WITH MEMBER
Measures.[Resell Cost as Negative]
AS -Measures.[Reseller Freight Cost]
SELECT
[Date].[Calendar Month of Year].Children ON COLUMNS,
[Product].[Product Categories].Children ON ROWS
FROM
[Adventure Works]
WHERE
{[Measures].[Resell Cost as Negative]}