Time Ranges (as of March 10, 2018)

Community Manager

Time Ranges (as of March 10, 2018)

This item has been identified as an outstanding known issue as of the March 10, 2018 platform release; a workaround is provided. 


Time Ranges

Three aggregation levels available for inclusion in a time range are rejected if they are not also added to the Model Calendar. These are Total of All PeriodsYear to Date (YTD), and Year to Go (YTG).

For example, if a source line item has a time range applied that includes Total of All Periods aggregation, but Total of All Periods in NOT included in the model timescale, the following formula is rejected:

Result = Source[SELECT: TIME.All Periods]

The same issue also occurs for Year to Date (YTD), and Year to Go (YTG) aggregations.

Add the level of aggregation to the Model Calendar in Settings Time Model Calendar Includes.