variance(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])
Calculate the variance of values in the specified column inside a group. This function is only available to elements in a section.
Parameters
tableLens the tableLens object of the table
column column label of the column to summarize
condition condition on the column to summarize
Return
variance of all values in a column
Example
text = variance(Table1.tableLens,"Quantity","Discount>0");
See Also
variance(cellRange), for the Table version.
| << sum(tablelens,column[,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | weightedAverage(tablelens,column,column2 [,condition]]) >> |