Working with calculation functions and related fields

As the name implies, aggregate functions in FileMaker Pro Calculations are used…for calculating various summarizations of sets of data.…So for example we can look at what our options are if we go…into Manage>Database.…Say for example that we want to change the Total Invoices Paid from a Number…field that requires us to enter data into it, into a Calculation field that…will dynamically update this information.…So let's do that, let's change our Calculation and hit Change, say OK.…This allows us to look over here in the upper right-hand corner at the…Aggregate Function options.…

You'll notice that we can average a set of Data, Count a set of data;…we've already seen List, a Return to Limited List of data, in some of the other…exercises in this course.…Max or Minimums, and a very common one is Sum, and some of the other ones that…are not quite as common, but also available to you if you need it.…Now when you choose one of these functions, you'll see that it has at least one…parameter that's required and that's a field. What these brackets mean…