weightedAverage(tablelens,column,column2 [,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 weighted average of values in the specified columns 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
column2 column label of the second column to summarize
condition condition on the group to summarize
Return
weightedAverage of all values in a column
Example
text = weightedAverage(Table1.tableLens,"Total",
"Quantity","Discount>0");
See Also
weightedAverage(column, column2[, group[,condition]]), for the Section version.
| << variance(Tablelens,column[,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | SI.3 Tab Object >> |