O'Reilly logo

Learn FileMaker Pro 10 by Jonathan Stars

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required