| title | - (Negative) (MDX) | Microsoft Docs |
|---|---|
| ms.date | 06/04/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
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]}