Operators - Arithmetic

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

You can use arithmetic operators in Data Mining Extensions (DMX) for arithmetic computations in Microsoft SQL Server Analysis Services, including addition, subtraction, multiplication, and division.

The following table identifies the arithmetic operators that DMX supports.

Operator Description
+ (Add) (DMX) Adds two numbers together.
- (Subtract) (DMX) Subtracts one number from another number.
* (Multiply) (DMX) Multiplies one number by another number.
(Divide) (DMX) 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.

See Also

Data Mining Extensions (DMX) Reference
Data 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)
General Prediction Functions (DMX)
Operators (DMX)
Structure and Usage of DMX Prediction Queries
Understanding the DMX Select Statement