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.5) | concat(cellRange) >> |