Aggregate Functions
Aggregate functions apply to a group of fields in related records or repeating fields.
|
Syntax |
Data Type Returned |
|---|---|
|
Average ( field {; field...} ) |
Number |
|
Count ( field {; field...} ) |
Number |
|
Max ( field {; field...} ) |
Text, Number, Date, Time, Timestamp |
|
Min ( field {; field...} ) |
Text, Number, Date, Time, Timestamp |
|
StDev ( field {; field...} ) |
Number |
|
StDevP ( field {; field...} ) |
Number |
|
Sum ( field {; field...} ) |
Number |
|
Variance ( field {; field...} ) |
Number |
|
VarianceP ( field {; field...} ) |
Number |