An aggregate function can be used to provide summary data for a row in a table or for a provided list of values.
Function |
Supported Areas |
Description |
AVG |
SELECT, COMPUTE, LAVG, Data Browser, Query Wizard, Query Builder, Form/Report/Label Expressions |
Computes the numeric average. R:BASE rounds averages of integer values to the nearest integer value and currency values to their nearest unit. |
COUNT |
SELECT, COMPUTE, Data Browser, Query Wizard, Query Builder, Form/Report/Label Expressions |
Determines how many non-null entries there are for a particular column item. |
LISTOF |
SELECT, Query Builder, Form/Report/Label Expressions |
Creates a text string of the values separated by the current comma delimiter character. The LISTOF function can be used to populate a variable with a list of values from multiple rows. |
MAX |
SELECT, COMPUTE, LMAX, Data Browser, Query Wizard, Query Builder, Form/Report/Label Expressions |
Selects the maximum numeric, time, date, or alphabetic value in a column. |
MIN |
SELECT, COMPUTE, LMIN, Data Browser, Query Wizard, Query Builder, Form/Report/Label Expressions |
Selects the minimum numeric, time, date, or alphabetic value in a column. |
PSTDEV |
Calculates population standard deviation. |
|
PVARIANCE |
Determines population variance. |
|
STDEV |
COMPUTE, Data Browser, Query Builder
|
Computes standard deviation. The standard deviation is a measure of how widely values are dispersed from the average value. |
SUM |
SELECT, COMPUTE, LAVG, Data Browser, Query Wizard, Query Builder, Form/Report/Label Expressions |
Computes the numeric sum. |
VARIANCE |
COMPUTE, Data Browser, Query Builder |
Determines variance. |
* Selecting aggregate functions, such as MIN and MAX, requires that R:BASE keeps an accumulator and choose to only use the first 80 characters for NOTE values. This matches the fact that if you sort on NOTE fields, the sort will be based on the first 80 characters only.