U.M. (Windows)

Summary of functions C-9
Summary functions
Use a summary function with summary fields.
When a database file is sorted, you can place a summary field in a
subsummary part to get subtotal values. (See “Adding a summary part”
on page 3-30.) Because sorting has the effect of grouping similar values,
the field you sort by is called a break field. FileMaker Pro calculates a
subtotal for each group of records with a common value in the break
field, letting you “break out” that range from the rest of the database.
The GetSummary function has the effect of a summary field in a
subsummary or grand summary part, performed from within a
calculation. To calculate a subsummary value, you must sort by the
break field to get appropriate results in a GetSummary function.
Syntax Definition
GetSummary (summary field,
break field)
GetSummary (summary field,
summary field)
Returns the value of summary field for the current
range of records when records are sorted by break
field; otherwise, returns an empty result. This is
equivalent to calculating a subsummary.
Returns the value of summary field for the current
found set of records. This is equivalent to calculating
a grand summary.
A calculation using GetSummary is unstored.
Break field
Summary field for subsummary
Summary field for grand
summary
Summary field for subsummary