2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Functions
Using Calculations - 230
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-252 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-221 for instructions on creating
calculations. See “Usage Conventions” on page 9-227 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.