Arithmetic Operators (DMX)

  • Article

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

Reference

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 Select Statement (DMX)