Great idea calculating cumulative balances for capital gains from AFR data! Has already helped in a couple returns, although I appear to be reviewing one with a glitch. The cumulative balance is negative but it still wants to be carried over to the NetCapLoss worksheet:
When I quickfix the review message, the negative balance is carried to the NetCapLoss schedule and does some odd things:
And if I click the cell:
This doesn’t appear to be the intended operation for this function?