This item has been identified as an outstanding known issue as of the March 10, 2018 platform release; a workaround is provided.
Issue
|
Workaround
|
---|---|
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 Periods, Year 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. |