countDistinct(cellRange)

Calculates the number of distinct values in the specified column inside a cell range. This function is only available to fixed Table elements.

Parameters

cellrange the start and end of cell range of the column to be counted (distinctly)

Return

number of distinct values in a cellrange

Example

text= countDistinct('[1,state]:[5,state]');

See Also

countDistinct(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.

<< count(cellRange) © 1996-2013 InetSoft Technology Corporation (v11.5) max(cellRange) >>