populationVariance(column[, 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 population variance of values in the specified column inside a group. This function is only available to elements within a Section.
Parameters
column column label of the column to summarize
group column label of the group to summarize
condition condition on the group to summarize
Return
population variance of all values in a group
Example
text = populationVariance("Quantity","State",
"field['Discount']>0");
See Also
populationVariance(cellRange), for the Table version.
variance(column[, group[,condition]]), for the sample version.
SI.22, Section Object, for additional functions pertaining to Sections.
Sections, for scripting issues related to Sections.
| << populationStandardDeviation(column[, group,condition]) | © 1996-2013 InetSoft Technology Corporation (v11.4) | pthPercentile(p, column[, group[,condition]]) >> |