Popular FileMaker Aggregate Functions

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

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

The aggregate functions are a set of functions that are available for calculations and scripts that can operate across many rows of a repeating field or a set of related records. These are great for getting live statistics on areas in your solution. A common trick is to have a file related to itself and use an aggregate function to give you things such as a count or average. Some available aggregate functions are Average, Count, List, Max, Min and Sum.

Returns the average value of a selected field. This field can be a repeating field or a field from a set of related records. The average function is intelligent enough to pass over any empty fields that it references.

This function counts the number of valid, populated entries in an indicated field. Good to use to count the number of related records in another database. It is important to know that the Count function is intelligent enough to ignore empty fields and will not count them.

The list function will provide you a return-delimited data list from a related data field or a repeating field. For the most part, this function is used for gathering related data in one large block and then using it for correspondence. For example, a list of related invoices in which you want to include in a batch email to each client in a found set. It is also possible that you would use the list function to pull a collection of related data as a list and then parse it out by using some of the value related text functions.

This function returns the highest value in a field, a repeating field or a set of related fields.

This function returns the smallest value in a field, a repeating field or a set of related fields.


The Sum function gives the total amount of a repeating field or perhaps more useful, a related field.
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.