variance(column[, group[,condition]])

Calculates the (sample) 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

variance of all values in a group

Example

text = variance("Quantity", "State", "field['Discount']>0");

See Also

variance(cellRange), for the Table version.

populationVariance(column[, group[,condition]]), for the population version.

SI.22, Section Object, for additional functions pertaining to Sections.

Sections, for scripting issues related to Sections.

<< sum(column[, group[,condition]]) © 1996-2013 InetSoft Technology Corporation (v11.5) weightedAverage(column, column2[, group[,condition]]) >>