YTD and YTG returning zero
I'm trying to calculate YTD actual revenue, and YTG budget revenue but they are returning zero.
For example: this returns zero -
module.Revenue'[SELECT: VERSIONS.Actual, SELECT: TIME.YTD, SELECT: Products.X]
This statement works when I replace TIME.YTD with TIME.'current period', so the issue just relates to TIME.YTD.
The calendar for the line item is set to a current year time range, with YTD and YTG enabled.
I have the same issue with YTG budget.
Anyone have any thoughts?!