• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint

### Aggregate Functions

All these functions have similar syntax. They take one or more fields and aggregate them. If the field is a repeating field, all the repetitions are aggregated. A list of fields can include repeating fields, local fields, or related fields; it can also include a function (such as if) that returns 0 or 1 field. If the fields in the aggregation list are repeating fields and the result of the calculation is a repeating field, the aggregation is done for each of the repetitions. However, if the result of the calculation is not a repeating field, the values are simply aggregated.

##### Table B.1. Aggregate Functions
FunctionResult
Average (field1 {; field2...})Number
Count (field1 {; field2...})Number
Max (field1 {; field2...})Number
Min (field1 {; field2...})Number
StDev (field1 {; field2...}) (Standard deviation for sample: n-1)Number
StDevP (field1 {; field2...}) (Standard deviation for population: n)Number
Sum (field1 {; field2...})Number
Variance (field1 {; field2...}) (Variance for sample: n-1)Number
VarianceP (field1 {; field2...}) (Variance for population: n)Number

PREVIEW

Not a subscriber?

Start A Free Trial

• Create BookmarkCreate Bookmark
• Create Note or TagCreate Note or Tag
• PrintPrint