| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|---|
Arithmetic Operators |
Arithmetic Operators |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
mdx |
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 ^ operator.
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.