2.0

Functions
Using Calculations 9-11
Functions
This section defines each OmniForm function and shows how to use it
in a calculation. Functions are listed alphabetically. See “Functions —
Quick Reference” on page 9-33 for an overview of each function.
Functions are single words used by OmniForm to represent operations
within a calculation. Functions can use field values, information you
enter, and information from outside sources such as the computer date.
See “Creating a Calculation” on page 9-2 for instructions on creating
calculations. See “Usage Conventions” on page 9-8 for a list of the
conventions used in this chapter.
The format of the values returned in the examples is dependent on:
•The
Language
selection in the
International
tab of the Options
dialog box
•The
Format
selection in the
Properties
tab of the Object Definition
dialog box for the selected object
Abs (Absolute Value)
The Abs function returns the positive value of a number or numeric
expression.
Usage Example
Abs[num1]
If the field [num1] = -50
Then the calculation Abs[num1] returns 50
In the example below, the
Amount Paid
field is subtracted from the
Bill
Amount
field and placed in the
Difference
field. The absolute value of the
difference appears in the
Credit
field.