Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index

Aggregate Functions

Scroll Prev Top Next More

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

SELECT

Calculates population standard deviation.

PVARIANCE

SELECT

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.