Previously, the TM1 Performance Modeler documentation did not provide details about the Time Average function. This function returns the average value calculated across all time periods, the first period only, or the last period only.
This function returns the average value calculated across all time periods, the first period only, or the last period only.
This function is available on the Aggregation tab of the Expression Editor when you are working with a cube calculation or with a C calculation in a dimension.
- Specifies the type of value to return. The allowed values are:
- Time Average: calculates the average as sum / number of periods
- First Period: uses the data from the first period only
- Last Period: uses the data from the last period only
- Zero: returns zero
For First Period and Last Period, the expression looks to each consolidation member for the attribute "last period" or "first period" and uses that attribute to determine where to get the Time Average value.
The member Headcount could use a function of =Time Average("Time Average") to calculate the average headcount over time periods.
Or, if you want the Headcount member to use the data from the last time period only, use the function =Time Average("Last Period").
17 June 2018