170
Hi everyone
is it possible in management reported to have a column for actual YTD based on periods in budget?
what I mean if I have a budget that contains data for period 4 and period 5 I want the actual YTD only pickup period 4 and Period 5 but I want that to be automated based on periods in budget file rather than change it manually as we have 100 budgets with different start dates
Kind regards
If you wanted a budget column to only pick up data for periods 4 to 5, you could hard code that range into the Period cell of the column. But it won't be automated. You'd need to update this. You could do something like BASE : BASE-1. That would pull in data for the base period to one period back. So if the base period in the report was set to 9, you'd get data for periods 9 and 8. You could also do something like 4 : BASE. If the base period in the report was 9, you'd get data for periods 4 through 9.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,537
Super User 2024 Season 2
#2
Martin Dráb
228,520
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
