average(tablelens,column[,condition])
average(tablelens,column[,condition])
concat(tablelens,column[,condition])
correlation(tablelens,column1,column2 [,condition])
count(tablelens,column[,condition])
countDistinct(tablelens,column[,condition])
covariance(tablelens,column, column2[, group[,condition]])
max(tablelens,column[,condition])
median(tablelens,column[,condition])
min(tablelens,column[,condition])
mode(tablelens,column[,condition])
nthLargest(tablelens,n,column[,condition])
nthMostFrequent(tablelens,n,column [,condition])
nthSmallest(tablelens,n,column[,condition])
populationStandardDeviation(tablelens,column [,condition])
populationVariance(tablelens,column [,condition])
pthPercentile(tablelens,p,column[, group,condition])
product(Tablelens,column[, condition])
standardDeviation(tablelens,column [,condition])
sum(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.5) | concat(tablelens,column[,condition]) >> |