countDistinct(tablelens,column[,condition])

Calculates the number of distinct values in the specified column.

Parameters

tableLens the tableLens object of the table

column column label of the column to summarize

condition condition on the column to summarize

Return

number of distinct values in a column

Example

text=countDistinct(Table1.tableLens,'Quantity',
   "Discount>0");

See Also

countDistinct(cellRange), for the Table version.

<< count(tablelens,column[,condition]) © 1996-2013 InetSoft Technology Corporation (v11.4) covariance(tablelens,column, column2[, group[,condition]]) >>