weightedAverage(column, column2[, group[,condition]])
average(column[, group[,condition]])
concat(column[, group[,condition]])
correlation(column, column2[, group[,condition]])
count(column[, group[,condition]])
countDistinct(column[, group[,condition]])
covariance(column, column2[, group[,condition]])
max(column[, group[,condition]])
median(column[, group[,condition]])
min(column[, group[,condition]])
mode(column[, group[,condition]])
nthLargest(n, column[, group[,condition]])
nthMostFrequent(n, column[, group[,condition]])
nthSmallest(n, column[, group[,condition]])
populationStandardDeviation(column[, group,condition])
populationVariance(column[, group[,condition]])
pthPercentile(p, column[, group[,condition]])
product(column[, group[,condition]])
standardDeviation(column[, group[,condition]])
sum(column[, group[,condition]])
Calculates the weighted average of values in the specified columns inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
column2 column label of the second column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
weighted average of all values in a group
Example
text = weightedAverage("Total","Quantity","State",
"field['Discount']>0");
See Also
weightedAverage(tablelens,column,column2 [,condition]]), for the Table version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << variance(column[, group[,condition]]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | SI.2.3 Fixed Tables >> |