nthSmallest(n, cellRange)

Calculates the nth smallest value in the specified column inside a cell range. This function is only available to fixed Table elements.

Parameters

n the nth smallest value to search

cellrange the start and end of cell range whose

aggregate is to be calculated

Return

nth smallest value in a cellrange

Example

text = nthSmallest(2,'[1,price]:[5,price]');

See Also

nthSmallest(n, column[, group[,condition]]), for the Section version.

SI.6, Table Object , for additional functions pertaining to Tables.

Data Tables, for scripting issues related to fixed Tables.

<< nthMostFrequent(n, cellRange) © 1996-2013 InetSoft Technology Corporation (v11.5) populationStandardDeviation(cellRange) >>