Skip to main content Skip to complementary content

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 data load script and in chart expressions.

For example, in a visualization, a range function can calculate a single value from an inter-record array. In the data 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.

Information noteRange functions replace the following general numeric functions: numsum, numavg, numcount, nummin and nummax, which should now be regarded as obsolete.

Basic range functions

Counter range functions

Statistical range functions

Financial range functions

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!