Functions Reference

FILEMAKER FUNCTIONS REFERENCE 205
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.
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)
Parameters
summaryField - field of type summary, or an expression that returns a reference to one.
breakField - field, or an expression that returns a reference to one. To calculate a grand summary
value, use the same summary field for both the summary field and the break field parameters.
GetSummary must be set up in the same table as the break field.
Data type returned
number, date, time, timestamp
Originated in
FileMaker Pro 6.0 or earlier
Description
This function produces subsummary values. If the database file isn’t sorted by the break field, the
result is blank.
When a summary field is also used as the break field, returns the summary field value for the entire
found set of records (a grand summary value).
Use GetSummary to capture summary values when you want to:
• use summary values in a calculation
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.