Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

GetSummary(summaryField;breakField)

summaryField - 

 that returns a reference to one.

breakField - field, or an expression that returns a reference to one. To calculate a 

 value, use the same summary field for both the summary field and the 

 parameters.

The GetSummary function must be set up in the same table as the break field. 

number, date, time, timestamp

Returns the value of summaryField for the current range of 

 by breakField. This produces 

. 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 

 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 

Calculations using the GetSummary function are 

You can get similar results using a 

 relationship and “Aggregate functions” 

on page 17. For more information, see FileMaker Pro help.

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 

 if the current charge is greater than three 

times the average charge.