4.0

Operators
Using Calculations 209
Usage Conventions
Substitute the appropriate field name where you see
num
and
str
in the
function examples. Parentheses are required where indicated. Below is
a list of conventions showing operator and function usage.
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 t a 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 207 for detailed
information.
Operator Function
date
date value: the expression must evaluate to a valid date
time
time value: the expression must evaluate to a valid time
num
number or numeric expression; num1, num2, and so forth indicate
additional number values
str
text string: str1, str2, and so forth indicate additional string values
...
additional repeating values of the given type may be entered
[ ]
brackets inserted around field names
log exp
logical expression
true exp
true expression
false exp
false expression