Range functions

The range functions are functions that take an array of values and produce a single value as a result. All range functions can be used in both the load script and in chart expressions.

For example, in a chart, a range function can calculate a single value from an inter-record array. In the load script, a range function can calculate a single value from an array of values in an internal table.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

Note: Range functions supersede the following general numeric functions: numsum, numavg, numcount, nummin and nummax. These can still be used, but are not recommended.

Basic range functions

Counter range functions

Statistical range functions

Financial range functions