Calculation Overview
208 Chapter 8
• 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
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.
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
