average(tablelens,column[,condition])

Calculates the average of 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

average of all values in a column

Example

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

See Also

average(cellRange), for the Table version.

<< SI.2.4 Global Objects © 1996-2013 InetSoft Technology Corporation (v11.4) concat(tablelens,column[,condition]) >>