Calculation Overview
8 Using Calculations
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.
Use the
List Separator
selection in the
Number
tab of the
Regional
Settings
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 sep-
arator 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.
Use the
Decimal symbol
selection from the
Number
tab of the
Regional Settings
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 to see it more
clearly.
• Calculations are performed in tabbing order.
• If a calculation contains another field that has a calculation, the
other field’s calculation is performed first.
To Next Page
Loading...
Need help?
General
