YTD and YTG returning zero
Hi,
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?!
Thanks
Declan
Answers
-
@ddevine Have you checked your summary methods on the revenue line item? Based on what you described, the summary method could be off and when you do a select, you're looking at the built in summary of that line item and not calculating on the fly.
Here is a helpful Anapedia article on this: https://help.anaplan.com/b3e0589c-8a5d-4ac3-afa4-1377d1224b85-Calculation-Functions-%E2%80%93-interaction-with-time-ranges-and-superset
2 -
Thanks Trentb
I found the issue, the time range of the two source data modules didn't employ YTD and YTG.
So I applied a new time range to those and now my own module is working.
So the chain of data is coming from the source data module A, into module B which applied more dimensions, into my module C. The summary type in my module is Sum.
Thanks for your help.
Regards,
Declan
0
