You are here: Building Expressions > Expression Builder > How Expressions are Evaluated

How Expressions are Evaluated

Expressions are evaluated from left to right, according to the following rules:

Operators are evaluated in order of arithmetic precedence. Use parentheses () to modify the order in which the expression is evaluated. Each operator works only if its operands are of an acceptable type. See the examples below for details.
When character strings of different lengths are compared, the shorter of the two lengths is used. If the Exact Character Comparisons preference is turned on, the longer of the two lengths is used.
If numbers with different precision are mixed in numerical operations, the result retains the decimal places of the operand with the largest number of decimal places in the expression.

For example:

4+5.0=9.0

1.1*1.1=1.2

6*2.000000=12.000000