2.0

Calculation Overview
Using Calculations 9-7
Using the Recalculate... Command
Recalculating records applies any new or changed calculations to
all
selected records in a database. Until you use the
Recalculate...
command,
new or changed calculations apply only to new records or to current
records whose relevant field entries change. See “Recalculating
Records” on page 8-13 for detailed information.
Calculation Guidelines
Keep these guidelines in mind as you work with calculations:
• OmniForm automatically inserts list separators, parentheses, and
brackets when you use the Calculation Builder or the Auto
button, and when you click the Accept Calculation button.
• OmniForm automatically removes extra spaces (except a space in
a field name) when it accepts a calculation.
You can insert spaces between operators and after commas when
creating a calculation if this helps you see it more easily.
• Brackets ( [] ) must enclose a field name that contains a space.
[Quantity Ordered] * [Unit Price]
OmniForm does not automatically insert brackets around a
manually created field name that contains a space.
• Parentheses (
()
) must enclose an entire function.
Sum
(
[Price1],[Price2]
)
This tells OmniForm where the function begins and ends.
• You must insert a comma between fields in a manually created
function.
Sum
(
[Price1]
,
[Price2])
• If you manually enter a decimal number in a calculation, you
must use the decimal selection selected in the Numbers control
panel.
•Quotes ( “ ” ) must enclose a text string.
If([Name1]=
”
Ann
”
,
”
Dear Ann:
”
,
”
Dear Customer:
”
)
• If you change a field name and that field is part of a calculation,
you must change the field name in the calculation as well.
OmniForm cannot perform the calculation otherwise.
• Calculations are performed in tabbing order.
• If a calculation contains another field that has a calculation, the
other field’s calculation is performed first.