Arithmetic Operators
You can use arithmetic operators in Multidimensional Expressions (MDX) for any arithmetic computations, including addition, subtraction, multiplication, and division.
MDX supports the arithmetic operators listed in the following table.
Operator | Description |
---|---|
+ (Add) | Adds two numbers. |
/ (Divide) | Divides one number by another number. |
* (Multiply) | Multiplies two numbers. |
- (Subtract) | Subtracts two numbers. |
^ (Power) | Raises one number by another number. |
Note
MDX does not include a function to obtain the square root of a number. To obtain the square root of a number, raise it to the power of 0.5 using the ^ operatior.
Order of Precedence
The following rules determine the order of precedence for arithmetic operators in an MDX expression:
When there is more than one arithmetic operator in an expression, MDX performs multiplication and division first, followed by subtraction and addition.
When all arithmetic operators in an expression have the same level of precedence, the order of execution is left to right.
Expressions within parentheses take precedence over all other operations.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om