Functions Reference

154 FileMaker Functions Reference
Description
Returns the value of summaryField for the current range of records when the database
file is sorted by breakField. This 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 the GetSummary function to capture summary values when you want to:
• Use summary values in a calculation
• Display subsummary values in Browse mode or in a body part
Calculations using the GetSummary function are unstored.
Note You can get similar results using a self-join relationship and Aggregate functions,
page 9. For more information, see FileMaker Pro Help.
Examples
GetSummary(Total Sales;Country) returns a summary of all records pertaining to
the value in the Country field.
GetSummary(Total Sales, if(Number of Countries > 1, Country, Sales
Zone)) returns a summary of Total Sales by Country if Number of Countries is greater
than 1. Otherwise, it returns a summary of Total Sales by Sales Zone.
GetSummary(Total Sales;Total Sales) produces a summary of all records
(similar to using a summary field, which is a total of total sales).
If(ThisCharge > 3 * GetSummary(AvgCharge;Customer), “Verify this
charge”, “ “) displays Verify this charge if the current charge is greater than three
times the average charge.