sum(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 sum 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
sum of all values in a column
Example
text = sum(Table1.tableLens,"Quantity","Discount>0");
See Also
sum(cellRange), for the Table version.
| << standardDeviation(tablelens,column [,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | variance(Tablelens,column[,condition]) >> |