© Mark Conway Munro 2017

Mark Conway Munro, Learn FileMaker Pro 16, https://doi.org/10.1007/978-1-4842-2863-0_19

19. Aggregate, Summary, and Repeating Functions

Mark Conway Munro

(1)Lewisburg, Pennsylvania, USA

There are three categories of functions that handle the manipulation of multiple values.

Aggregate Function Reference

Aggregate functions are used to summarize fields and to perform statistical computations on numbers, dates, and times.

FileMaker provides the following built-in aggregate functions:

  • Average

  • Count

  • List

  • Max

  • Min

  • Steve

  • StDevP

  • Sum

  • Variance

  • VarianceP

These functions can accept a single repeating field or a list of non-repeating, repeating, or related fields. Due to the similarity in behavior and the number of possibly different ...

Get Learn FileMaker Pro 16: The Comprehensive Guide to Building Custom Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.