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 - 234
Exp (Exponentiation)
The Exp function returns the value of the constant e to the power of a
number or numeric expression. The value of e, the base of natural
logarithms, is approximately 2.71828. This function is the inverse of the
Ln function.
Usage Example
Exp([num1])
If the field [num1] = 3
Then the calculation Exp([num1]) returns 20.08553692
In the example below, the
Exp
field is calculated using the number in the
Value
field.
FV (Future Value)
The FV function returns the future value of an investment. The future
value is determined by computing a series of constant periodic
payments made at the end of each period, earning a fixed interest rate
per period, for a fixed number of periods.
Usage Example
FV([payment num],[rate num],[num of periods])
If the payment is $100, the annual interest rate is 8%, and the number of years is 30
Then the calculation FV([payment num],[rate num],[num of periods]) returns
11,328.32 (approximately)
It is important to have the fields in the proper order as listed above.
In a different example below, the future value of a savings plan is
calculated and put in the
Future Value
field.