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

Calculates the average 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

average of all values in a group

Example

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

See Also

average(cellRange), for the Table version.

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

Sections, for scripting issues related to Sections.

<< SI.2.2 Tables and Sections © 1996-2013 InetSoft Technology Corporation (v11.4) concat(column[, group[,condition]]) >>