Average function
Applies to: TBM Studio 12.0 and later
Returns the average value in a specified column.
Where to use
This function can be used in:
- Data sets (with column and rollup arguments)
- Calculated metrics and reports with metric columns (with rollup arguments)
- Formula columns in report tables (with column and rollup arguments)
- Dynamic text
- Allocation source
- Formulas
Syntax
Average([rollup_operator]column)
Arguments
rollup_operator
@, SOURCE, ~, or TARGET. This argument is optional and used only with metrics. See Rollup Operators.
column
The column to be averaged.
Return type
The same as the type of column.
Example
=Average(@Space)
=Average(Space)
See also: