I would like create a monthly P&L that uses the Actuals ledger for Start Period through End Period and then uses Budget ledger for “End Period +1” through Period 12.
Currently I update the data source in the appropriate column each month within the column set. I would like to find a way to dynamically select the correct ledger based on End Period.
Something like the following for the column representing the Period 7 . . .
=IIf(Left(@EndPeriod,2)>=7, ‘Actuals Ledger’, ‘Budget Ledger”)
Best answer by vkumar
View original