Aggregate
|
Name |
Syntax |
Description |
|---|---|---|
|
Avg |
Avg(FIELDNAME) |
Returns the average of all non-null values of the specified field. |
|
Count |
Count(FIELDNAME) |
Returns a count of non-null values of the specified field. |
|
CountDistinct |
CountDistinct(FIELDNAME)
|
Returns a count of the distinct values of the specified field. |
|
CountRows |
CountRows()
|
Returns the number of rows, including rows with null values. |
|
Max |
Max(FIELDNAME)
|
Returns the maximum value from all values of the specified field. |
|
Min |
Min(FIELDNAME) |
Returns the minimum value from all non-null values of the specified field. |
|
StDev |
StDev(FIELDNAME) |
Returns the standard deviation of non-null values based on a sample of the entire population: 
|
|
StDevP |
StDevP(FIELDNAME) |
Returns the standard deviation of non-null values based on the entire population: 
|
|
Sum |
Sum(FIELDNAME) |
Returns a sum of the values of the specified field. |
|
First |
First(FIELDNAME)
|
Returns the first of the values of the specified field. |
|
Last |
Last(FIELDNAME) |
Returns the last of the values of the specified field. |
|
There is no specific function for the relative standard deviation. This must be manually calculated as (Stdev/Avg*100). |
Aggregating functions always refer to all records in a scope and return only one value. This value is either calculated from those records or selected according to specific criteria. Therefore, aggregating functions are automatically used, for example, for the creation of table headers or footers. You can use aggregating functions if you need to summarize your data.