Chapter 13

Real-World Calculations—Part 2


This chapter continues our discussion about basic and complex calculations you might really use. Since I introduced you to a number of techniques for building complex calculations in the last chapter, I’ll spend more time on specific uses in this chapter.

Aggregate Functions

Aggregate functions are meant to get information from a number of records, related records, or repeating fields. That really makes sense when you look at the names in this group of functions:




Max (maximum)

Min (minimum)

StDev (standard deviation)

StDevP (standard deviation of population)


Variance (spread)

VarianceP (population spread)

Aggregate Examples

We already used one of the aggregate functions ...

Get Learn FileMaker Pro 10 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.