Help

FILEMAKER PRO HELP 882
Last(Payments::PaymentDate) returns the payment date in the last matching record in the
Payments table.
Last(if(IsEmpty(Company);PersonalPhone;WorkPhone)) returns the last non-empty
phone number from the repeating field PersonalPhone when the Company field is empty. If the
Company field is not empty, the function returns the last non-empty phone number from the
repeating field WorkPhone.
Related topics
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Summary functions
Summary functions produce a summary of all records in the found set, or subsummary values for
records in different groups. Formulas can contain more than one summary function. Summary
functions calculate more slowly than other functions because they generate values for a range of
records.
An alternative way to generate similar calculated results is to use Aggregate functions to summarize
data in
related records (whether or not they appear in a portal). See Aggregate functions and
information about summarizing data in portals.
Click the function name for details.
Related topics
About functions
About formulas
GetSummary
Purpose
Returns the value of summaryField for the current range of records when the database file is
sorted by breakField.
Format
GetSummary(summaryField;breakField)
This function Returns
GetSummary The value of the summary field for the current range of records when the database
file is sorted by the break field.