These two categories of functions handle financial and advanced mathematical calculations.
Financial Function Reference
Financial functions are used to calculate financial results for investment and interest payments. FileMaker provides the following built-in financial functions:
FV
NPV
PMT
PV
FV
The FV function returns the future value of an investment, based on a fixed interest rate and payment amount for a specified period of months.
Format | FV ( payment ; interestRate ; periods ) |
Parameters | payment = a number indicating the amount ... |
