nthSmallest(n, column[, group[,condition]])

Calculates the nth smallest value in the specified column inside a group. This function is only available to elements within a Section.

Parameters

n the nth smallest value to search

column column label of the column to summarize

group column label of the group to summarize

condition condition on the group to summarize

Return

nth smallest value in a group

Example

text = nthSmallest(2,"Quantity","State",
   "field['Discount']>0");

See Also

nthSmallest(n, cellRange), for the Table version.

SI.22, Section Object, for additional functions pertaining to Sections.

Sections, for scripting issues related to Sections.

<< nthMostFrequent(n, column[, group[,condition]]) © 1996-2013 InetSoft Technology Corporation (v11.4) populationStandardDeviation(column[, group,condition]) >>