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
RangeMax() returns the highest numeric values found within the expression or field.
RangeCorrel() returns the correlation coefficient for two sets of data. The correlation coefficient is a measure of the relationship between the data sets.
RangeNPV() returns the net present value of an investment
based on a discount rate and
a series of future periodic payments (negative values) and incomes (positive values).
The result has a default number format of money.
RangeXIRR() returns the internal rate of return (yearly) for a
schedule of cash flows that is not necessarily periodic. To calculate
the internal rate of return for a series of periodic cash flows, use the
RangeIRR
function.
RangeXNPV() returns the net present value for a schedule of cash flows (not necessarily periodic) represented by paired numbers in the expressions given by pmt and date. All payments are discounted based on a 365-day year.