Is it possible to roll forward balance within the same List?
I have Deal List and Funds List with their Top Levels and Beg. Available Fund, Fund Utilization for the deal, and Remaining Fund as the Line Items.
In module, Deal list and Funds List appearing in the Rows (Each deal has the same Funds list appearing again) and Line items in columns.The scenario is, one by one each Fund will utilize their available amount for all the deals so whatever left after spending on Deal 1 the Remaining Fund will become Available Fund for Deal 2 and so on.
Is there any way I can roll forward the remaining amount deal by deal?
Never tried that but sounds like a good use case for Closing Balance summary.
Try setting up an account that has additions and reductions. Assuming you're scenario is time based you can simply use the ending balance at the beginning of your next deal. You'll also have a way to replenish the account if you have additions.