Announcements
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.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156