| title | - (Negative) (MDX) |
|---|---|
| description | - (Negative) (MDX) |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | mdx |
Performs a unary operation that returns the negative value of a numeric expression.
- Numeric_Expression
Numeric_Expression
A valid Multidimensional Expressions (MDX) expression that returns a numeric value.
A negative value that has the data type of the specified parameter.
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]}