Operators

The operators in table 1 can be used in formulas.

Table 1. Operators in GoPhast Formulas
Operator
Meaning
Data Types
Result type
=
equals
real numbers, integers, Booleans, text
Boolean
<>
not equals
real numbers, integers, Booleans, text
Boolean
>
greater than
real numbers, integers, Booleans, text
Boolean
<
less than
real numbers, integers, Booleans, text
Boolean
>=
greater than or equals
real numbers, integers, Booleans, text
Boolean
<=
less than or equals
real numbers, integers, Booleans, text
Boolean
and
and
Booleans
Boolean
or
or
Booleans
Boolean
xor
exclusive or
Booleans
Boolean
not
not
Booleans
Boolean
mod
modulus (remainder)
integers
integer
div
integer division
integers
integer
*
multiplication
real numbers, integers
real number, integer
/
division
real numbers, integers
real number, integer
+
addition or concatenation
real numbers, integers, text
real number, integer, text
-
subtraction
real numbers, integers
real number, integer


The operator precedence rules are shown in table 2.  Operators of equal precedence are evaluated in left to right order.

Table 2. Operator Precedence Rules in GoPhast Formulas
Operators
Precedence
()
first (highest)
not
second
and, mod, div, *, /
third
or, xor, +, -
fourth
=, <>, >, <, >=, <=
fifth (lowest)