Total not working correctly

dedelman_clng 

What I am trying to do is calculating Forecasted Payments, Forecasted Collections, Forecasted Opening, Funding and Forecasted Closing Balances.

Current Balance is TB Balance = Opening Balance of Current Month

Current Month Closing Balance = Opening Balance of Current Month +forecasted Collection -Forecasted Payments 

If Current Month Closing Balance is negative , we add an equal amount of Funding

So Current Month Closing Balance updated = Opening Balance of Current Month +forecasted Collection -Forecasted Payments +Funding

And we Cumulate this vCurrent Month Closing Balance updated to get the actual Closing balance across months , which drill up into years

1)

The formulas should work even when drilled down into the month level.

When drilled down into Sep 2020, the opening balance should be the TB Amount total( Current Trial Balance), which is coming correctly in my file.(Screenshot 1)

2)

But When rolling up into the year then 2020 opening balance should be also of current month, but currently is showing 0M,

this should be 16M(which is current month opening balance = TB Amount Total), also the total opening balance should be 16M in the above screen(and even when drilled down into the month level, the total opening balnce should be of the current month = TB Amount Total =16 M)(Screenshot 2)

3)

Also all the formulas should work when drilling into a single year(even the new cumulative balance updated, which I now realized that is not working- Screenshot 3)