Range functions

RangeMax() returns the highest numeric value found within the expression or field.

rangemax(first_expr[, Expression])

RangeMaxString() returns the last value in the text sort order that it finds in the expression or field.

rangemaxstring(first_expr[, Expression])

RangeMin() returns the lowest numeric values found within the expression or field.

rangemin(first_expr[, Expression])

RangeMinString() returns the first value in the text sort order that it finds in the expression or field.

rangeminstring(first_expr[, Expression])

RangeMode() finds the most commonly occurring value (mode value) in the expression or field.

rangemode(first_expr[, Expression])

RangeOnly() is a dual function that returns a value if the expression evaluates to one unique value. If this is not the case then NULL is returned.

rangeonly(first_expr[, Expression])

RangeSum() returns the sum of a range of values.All non-numeric values are treated as 0, unlike the + operator.

rangesum(first_expr[, Expression])

RangeCount() returns the number of values, both text and numeric, in the expression or field.

rangecount(first_expr[, Expression])

RangeMissingCount() returns the number of non-numeric values (including NULL) in the expression or field.

rangemissingcount(first_expr[, Expression])

RangeNullCount() finds the number of NULL values in the expression or field.

rangenullcount(first_expr[, Expression])

RangeNumericCount() finds the number of numeric values in an expression or field.

rangenumericcount(first_expr[, Expression])

RangeTextCount() returns the number of text values in an expression or field.

rangetextcount(first_expr[, Expression])

RangeAvg() returns the average of a range. Input to the function can be either a range of values or an expression.

rangeavg(first_expr[, Expression])

RangeCorrel() returns the correlation coefficient for two sets of data. The correlation coefficient is a measure of the relationship between the data sets.

rangecorrel(x_values , y_values[, Expression])

RangeFractile() returns the value that corresponds to the n-th fractile (quantile) of a range of numbers.

rangefractile(fractile, first_expr[ ,Expression])

RangeKurtosis() returns the value that corresponds to the kurtosis of a range of numbers.

rangekurtosis(first_expr[, Expression])

RangeSkew() returns the value corresponding to the skewness of a range of numbers.

rangeskew(first_expr[, Expression])

RangeStdev() finds the standard deviation of a range of numbers.

rangestdev(expr1[, Expression])

RangeIRR() returns the internal rate of return for a series of cash flows represented by the input values.

RangeIRR(value[, value][, Expression])

RangeNPV() returns the net present value of an investment based on a discount rate and a series of future payments (negative values) and incomes (positive values). The result has a default number format of money.

RangeNPV(discount_rate, value[, value][, Expression])

RangeXIRR() returns the internal rate of return 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.

RangeXIRR(values, dates[, Expression])

RangeXNPV() returns the net present value for a schedule of cash flows that is not necessarily periodic. The result has a default number format of money. To calculate the net present value for a series of periodic cash flows, use the RangeNPV function.

RangeXNPV(discount_rate, values, dates[, Expression])