U.M. (Mac OS)
Table Of Contents
- Preface: Getting help
- Chapter 1: FileMakerPro basics
- Chapter 2: Creating a database file
- Chapter 3: Laying out and arranging information
- Understanding layouts
- _
- Working with predefined layout types
- Arranging records in columns
- Managing layouts
- Working with layout parts
- Changing layout parts
- Working with all object types
- Working with graphic objects
- Working with fields in a layout
- Adding fields to a layout
- Adding merge fields
- Deleting a field from a layout
- Defining display formats for fields
- Determining data entry in fields
- Setting the tab order for data entry
- Adding scroll bars to fields
- Formatting repeating fields
- Adding borders, fill, and baselines to fields
- Defining value lists
- Formatting fields with value lists
- Working with text
- Chapter 4: Working with information in records
- Working in Browse mode
- Adding data to a file
- Selecting a field for data entry
- Adding and duplicating records
- Entering and changing data in fields
- Working with container fields
- Entering data from a value list
- Viewing and inserting data from another source
- Copying and moving values and records
- Using drag and drop to move information
- Replacing field values
- Working with records
- _
- Finding information
- Deleting records
- Sorting records
- Chapter 5: Using ScriptMaker and buttons
- Chapter 6: Previewing and printing information
- Chapter 7: Networking and access privileges
- Chapter 8: Importing and exporting data
- Chapter 9: Customizing FileMakerPro
- Chapter 10: Using data from related files
- Chapter 11: Publishing files on the Web
- About the World Wide Web
- About FileMaker Pro Web Companion
- Publishing your database on the Web—an overview
- Getting ready to publish your files on the Web
- Setting up FileMaker Pro Web Companion
- Configuring FileMaker Pro Web Companion
- Setting up Instant Web Publishing
- Database security
- Helping Web users find your database
- Custom Web Publishing
- Appendix A: Recovering damaged files
- Appendix B: Working with international files
- Appendix C: Summary of functions
- Index
Summary of functions C-13
Financial functions
Keep these points in mind:
1 Term is expressed in months
1 Interest rate is a value from 0.0 to 1.0, divided by 12 (months).
Trigonometric functions
Syntax Definition
FV (payment, interest rate, periods) Returns the future value of an investment based on
interest rate and payment for periods
NPV (payment, interest rate) Returns net present value of a series of unequal
payments (in a repeating field) made at regular
intervals using a fixed interest rate (in a number
field) per interval. (When payments contains equal
values, use the PV function.)
PMT (principal, interest rate, term) Returns the payment needed to meet the
requirements of principal, interest rate, term
PV (payment, interest rate, periods) Returns the present value of equal payments made
at regular periods, assuming a fixed interest rate
per payment
Choose FileMaker Help Index from the or Help menu, and then type:
E financial functions
Syntax Definition
Atan (number) Returns the trigonometric arc (inverse) tangent of
number. The arc tangent is the angle, in radians,
whose tangent equals number.
Cos (number) Returns the cosine of the angle (in radians) of
number
Degrees (number) Converts number from radians to degrees
(π/180 radians)
Ln (number) Returns the base-e (natural) logarithm of number
Log (number) Returns the common logarithm (base 10) of number,
which is any positive value
PI Returns the value of pi (π), approximately 3.14159
?