Data Transformation Engine Functions and Expressions Reference Guide

Chapter 1 - Expressions and Evaluations Operators
Functions and Expressions Reference Guide
30
Order of Operator Evaluation
Use parentheses to group operations. Expressions within parentheses are
evaluated before performing other operations. For example:
(UnitPrice – Discount) * Tax
The expression UnitPrice - Discount is evaluated before the rest of the
expression.
Some operators are evaluated before others according to standard rules of
precedence. Operators are evaluated in the following order:
Precedence Operators Description
first ( ) Operations within parentheses
second + and - unary plus and minus
The sign indicates a positive or
negative expression, for example:
- quantity*rate
third =, <, >, <=, >=, != comparative operators
fourth ^ logical operator "exclusive or"
fifth & logical operator "and"
sixth | logical operator "or"
seventh * and / multiplication and division
eighth + and - addition and subtraction
Note Operators of equal precedence are evaluated left to right.