| title | Arithmetic Operators | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/02/2016 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 1dff3e20-fe9d-4155-bf06-27d6458188e9 | |
| caps.latest.revision | 27 | |
| author | Minewiskan | |
| ms.author | owend | |
| manager | erikre |
[!INCLUDEtsql-appliesto-ss2008-all_md]
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.