| title | Arithmetic Operators | 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 |
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.
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.