Skip to Content
Former Member
Sep 24, 2012 at 09:44 AM

Rolling Actual-Budget


HI Experts

I am forced to open a new thread here so that a fresh ideas can come. I have a report in which the actual should be populated till current month and the rest will be populated by budget data. It is like, From Year beginning till previous close month, we will populate the ACTUAL data and the rest of the current year will be budget data. if the current month is August, the closed month is July. From January - July, the actuals get populated and the rest of the month - budget data get populated ?