Unary Operators
In Multidimensional Expressions (MDX), unary operators perform an operation on a single operand, such as returning the negative or positive value of a numeric expression.
MDX supports the unary operators listed in the following table.
Operator | Description |
---|---|
- (Negative) | Returns the negative value of a numeric expression. |
+ (Positive) | Returns the positive value of a numeric expression. |
The following example demonstrates the use of a unary operator to return the negative value of a measure:
WITH
MEMBER [Measures].[NegDiscountAmount] AS
-[Measures].[Discount Amount]
SELECT
{[Measures].[Discount Amount],[Measures].[NegDiscountAmount]} on COLUMNS,
NON EMPTY [Product].[Product].MEMBERS ON Rows
FROM [Adventure Works]
WHERE [Product].[Category].[Bikes]
In addition, MDX uses special unary operators to determine the aggregation operation performed by the RollupChildren function. For more information on these special unary operators, see Add a Custom Aggregation to a Dimension.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort: Gedurende 2024 worden GitHub Issues uitgefaseerd als het feedbackmechanisme voor inhoud. Dit wordt vervangen door een nieuw feedbacksysteem. Ga voor meer informatie naar:Feedback verzenden en bekijken voor