I was trying to create a report that had actuals for YTD and Budget for the remaining year, non-printing with just the totals.
MR doesn't seem to allow BASE:12 as an option.
this is super high level but this is what i am trying to accomplish:
Actual | Budget | Budget | Calc |
1:BASE | BASE:12 | BASE | a+b-c |
NP | NP | NP |
so basically in period 8 it would be
Actuals 1:8
+Budget 8:12
-Budget 8
------
Actual 1-8 and Budget 9-12
thanks,
-MH