About The FileMaker Summary Family Of Functions

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

This family of functions actually contains only one function and it is often misunderstood or completely missed by FileMaker designers. However, it is quite powerful and we have hopes that we may help bring some of the mysteries of this function to light.

GetSummary( summaryField ; breakField)
FMP Version: All Current Versions Of FileMaker

This function will give you the information in a summary field for a found set of records when sorted by a break field. It is not dependent on a layout part and can be used within other calculations. The function has the two parameters of summaryfield and breakfield. The summary field parameter obviously refers to the summary field you want to capture the data from. The breakfield is the field that must be sorted to obtain the sub summary total in a grouped value report for the summary field.

Here is a picture of the new layout assistant settings when you want to create a grouped report. The GetSummary function can be setup to mimic what you would see in a sub summary totals.

=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.