Product Documentation
Abstract
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.
Content
Purpose
This function returns the average value calculated across all time periods, the first period only, or the last period only.
=Time Average("TimeAverageType")
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.
Parameters
TimeAverageType
- 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.
Sample
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").
[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Performance Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27043781