2.0

Calculation Overview
Using Calculations - 226
Calculation Guidelines
Keep these guidelines in mind as you work with calculations:
• Brackets ( [] ) must enclose a field name that contains a space.
[
Quantity Ordered
]
*
[
Unit Price
]
OmniForm will not accept the calculation otherwise.
• Parentheses (
()
) must enclose an entire function.
Sum
(
[Price1],[Price2]
)
This tells OmniForm where the function begins and ends. You
may have more than one function in a calculation.
• You must insert a list separator between fields in a manually
created function.
Sum
(
[Price1]
,
[Price2])
Use the list separator from the Windows Control Panel.
Windows 95 users: use the
List Separator
selection in the
Number
tab of the
Regional Settings
control panel.
Windows NT and 3.1 users: use the
List Separator
in from the
International
control panel.
• OmniForm automatically inserts list separators, parentheses, and
brackets when you use the Calculation Builder or the Auto
button to create a calculation, and when you click the Accept
Calculation button to accept a calculation.
See the previous bulleted item for an explanation of the list
separator OmniForm uses.
• OmniForm does not automatically insert brackets around a
manually created field name that contains a space. You must
insert brackets manually.
• If you manually enter a decimal number in a calculation, use the
decimal selection from the Windows Control Panel.
Windows 95 users: use the
Decimal symbol
selection from the
Number
tab of the
Regional Settings
control panel.
Windows 3.1 and NT users: use the
Decimal separator
selection
from the
International
control panel.
•Quotes ( “ ” ) must enclose a text string.
If([Name1]=
”
Ann
”
,
”
Dear Ann:
”
,
”
Dear Customer:
”
)
• 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.