Previous
Previous
 
Next
Next

Arithmetic Operators

Table: Arithmetic Operators shows the OLAP DML arithmetic operators, their operations, and priority where priority is the order in which that operator is evaluated. Operators of the same priority are evaluated from left to right. When you use two or more operators in a numeric expression, the expression is evaluated according to standard rules of arithmetic. You must code a comma before a negative number that follows another numeric expression, or the minus sign is interpreted as a subtraction operator. For example, intvar,-4

Arithmetic Operators

Operator Operation Priority

-

Sign reversal

1

**


Exponentiation

2

*


Multiplication

3

/


Division

3

*


Addition

4

-

Subtraction

4