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 - 243
PMT (Payment)
The PMT function returns the payment amount required for a given
principal at a fixed interest rate per period, for a fixed number of payment
periods. It assumes payments are made at the end of each period.
Usage Example
PMT([principal num],[interest rate num],[num periods])
If the principal is $30,000, the annual interest rate is 9% (.75% monthly), and
the number of years is 30
Then the calculation PMT([principal num],[interest rate num],[num periods])
returns 241.39 (approximately)
It is important to have the fields in the proper order as listed above. In a
different example below, the
Monthly Payment
field is calculated based
on entries in the
Loan Amount, Interest Rate,
and
Years
fields.
Position
The Position function returns the starting position of the find string in a
given source string, beginning at the specified starting position of 1 from
the left. If the find string is not found, 0 is returned.
Usage Example
Position([source str],[find str],[start position num])
If a field contains the name Doe, John and you want to find the comma position
Then the calculation Position(“[source str]”,“,”,1) returns 4
In the example below, the Position function locates the comma. Other
functions are then used to extract the last name from the
Customer Name
field and place it in the
Customer Last Name
field.