2.0

Operators
Using Calculations 9-9
Operators
Operators represent mathematical, comparison, logical, and text
operations to be performed within a calculation. You must have an
operator between fields in a calculation.
For example, a calculation for a
To ta l
field might look like this:
[Price1] + [Price2] + [Price3]
The plus signs between the field names are the
Addition
operators in the
calculation.
The calculation could also look like this:
Sum([Price1],[Price2],[Price3])
The parentheses are the operators in the calculation. Commas, although
not operators, also separate the fields.
You must insert the proper parentheses, brackets, and commas when
you create a function manually or OmniForm will not accept the
calculation. See “Calculation Guidelines” on page 9-7 for detailed
information.
OmniForm automatically inserts commas, parentheses, and brackets
when you create a calculation with the Calculation Builder or the Auto
button, and when you click the Accept Calculation button.
Operator Buttons
See “Calculation Overview” on page 9-2 for instructions on creating
calculations.
Addition
Left
Parenthesis
Equal
Subtraction Not
Equal
Division
Power of
Concatenate Greater
Than
Less Than
Right
Parenthesis
Logical
And
Less Than or
Equal To
Greater Than
or Equal to
Logical
Or
Logical
Not
Multiplication