ISO FileMaker Magazine

So, what's the point of collecting all that data if you're not going to determine what it's telling you? Well, a lot of those burning questions are often answered with the power of the Aggregate functions.

Whether you simply need some total using the Sum() function or if you're an advanced developer writing crazy scripted loops using the List() function, you need to know how to use the Aggregate functions to achieve the desired results.

There are a few peculiarities about using the Aggregate functions, but once you've got them down you can decide how you want your database to behave. Using the Aggregate functions, you can store your aggregate data and move in the direction of better performance in favor of FileMaker figuring it out for you all the time. Or, you can just use FileMaker in the same way you've always been doing and simply take advantage of its easy power. Either way, it's all covered in this video about the Aggregate functions.