Hello Team, I need help creating a dynamic roll-forward measure for beginning and ending balances. The end balance for month 0 is rolled forward to become the beginning balance for month 1 and the end balance for month 1 is rolled forward to become the beginning balance for month 2. Does any one have some insights on how I can achieve this?
Check out how data mentor solves this
You can create a continued thread from this particular query To explore it further
@SamMcKay thank you for your response.
How do ensure that the measure follows this pattern:
Ending Balance (month 0) = Beginning balance (month 0)
- Payoffs (month 0) + HCL (month 0) + FC (month 0)
Ending Balance (month 1) = Ending balance (month 0)
- Payoffs (month 1) + HCL (month 1) + FC (month 1)
Ending Balance (month 2) = Ending balance (month 1)
- Payoffs (month 2) + HCL (month 2) + FC (month 2)
Basically the ending balance from the previous month becomes the beginning balance of the current month and is added to Payoffs, HCL, and FC of the current month.