There are twelve aggregate functions that extract and group data from a larger data set.

• DSum
• DAvg
• DCount
• DLookup
• DMin and DMax
• DFirst and DLast
• DStDev
• DStDevP
• DVar
• DvarP

These functions all have the same structure:

FunctionName( “ [Field Name] “,” [Dataset Name] “, “[Criteria] “ )

FunctionName is the name of the domain aggregation function being invoked;  Field Name refers to the field containing the data in question; DataSet Name refers to the table in play; and, Criteria limits the inclusion of data per the scope necessary.

These functions can provide everything from a total of the values listed to an average of those values to the standard deviation of the values listed. The Help menu has detailed information about the functions.