average(cellRange)

Calculates the average of values in the specified column inside a cell range. This function is only available to fixed Table elements.

Parameters

cellrange the start and end of cellrange whose average is to be calculated.

Return

average of all values in a cell range

Example

text = average('[1,quantity]:[5,quantity]');

text = average('[1,0]:[5,0]');

See Also

average(tablelens,column[,condition]), for the tableLens version.

average(column[, group[,condition]]), for the Section version.

SI.6, Table Object , for additional functions pertaining to Tables.

Data Tables, for scripting issues related to fixed Tables.

<< SI.2.3 Fixed Tables © 1996-2013 InetSoft Technology Corporation (v11.4) concat(cellRange) >>