.png)
Arithmetic Operators (DMX)
SQL Server 2005
You can use arithmetic operators in Data Mining Extensions (DMX) for arithmetic computations in Microsoft SQL Server 2005 Analysis Services (SSAS), including addition, subtraction, multiplication, and division.
The following table identifies the arithmetic operators that DMX supports.
| Operator | Description |
|---|---|
|
Adds two numbers together. | |
|
Subtracts one number from another number. | |
|
Multiplies one number by another number. | |
|
Divides one number by another number. |
The following rules determine the order of precedence for arithmetic operators in a DMX expression:
-
When there is more than one arithmetic operator in an expression, multiplication and division are calculated first, followed by subtraction and addition.
-
When all the arithmetic operators in an expression have the same level of precedence, the order of execution is left to right.
-
Expressions that are within parentheses take precedence over all other operations.
Reference
Data Mining Extensions (DMX) ReferenceData Mining Extensions (DMX) Function Reference
Data Mining Extensions (DMX) Operator Reference
Data Mining Extensions (DMX) Statement Reference
Data Mining Extensions (DMX) Syntax Conventions
Data Mining Extensions (DMX) Syntax Elements
Expressions (DMX)
Mapping Functions to Query Types (DMX)
Operators (DMX)
Prediction Queries (DMX)
Understanding the Select Statement (DMX)
