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 . . .
Using an expression (conditional) to select the Ledger is unavailable. But as a workaround, you may try the following : -
Add an additional column for each period using Budget ledger
Keep the column hidden. There is no direct option to hide the column, you can just set a visibility expression 1+1=1 and it will hide the column ( since the result is always false for the expression).
Use an expression on ‘value’ line to select the value from this hidden column based on the period condition. This is on actual column where the value from either Budget ledger or Actual ledger need to be picked.
This way you can use the value of hidden column (Budget ledger number ) on your expressions of visible columns
Using an expression (conditional) to select the Ledger is unavailable. But as a workaround, you may try the following : -
Add an additional column for each period using Budget ledger
Keep the column hidden. There is no direct option to hide the column, you can just set a visibility expression 1+1=1 and it will hide the column ( since the result is always false for the expression).
Use an expression on ‘value’ line to select the value from this hidden column based on the period condition. This is on actual column where the value from either Budget ledger or Actual ledger need to be picked.
This way you can use the value of hidden column (Budget ledger number ) on your expressions of visible columns
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.