Chapter 13

Real-World Calculations—Part 2

Introduction

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:

Average

Count

List8.5

Max (maximum)

Min (minimum)

StDev (standard deviation)

StDevP (standard deviation of population)

Sum

Variance (spread)

VarianceP (population spread)

Aggregate Examples

We already used one of the aggregate functions ...

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

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