I can see that argument that summing the credit and debit value of a particular row could be done at the data level or as a read-only property on the model or whatever. I need to do more than that. I need to add that value to the sum of that calculation from all the previous rows, as well.
I'm attaching a screenshot from Excel. What I need to do in my grid is implement the green balance column. Additionally, if a user enters a new record dated, say, 1/20/206 then I need that to add its net value to the balance as of 1/15/2016 and cascade that change in balance through to the 1/31/2016 row and to whatever other rows may also exist.
Is it your recommendation that that be done at the data level? That I should do a CommitEdit for the new row and then recalculate the balance column at the data level? The balance isn't stored anywhere. It's 100% calculated.
What I sort of expected the approach to be is something along the lines of how I'd have handled OnItemDataBound on an ASPX page a while back: basically declare a variable and do the math as each row was databound.
I'm hoping this explanation and the screenshot make more sense than my original post seems to have. The balance column isn't simply the balance of that row. That would be trivial. The balance the sum of all the balances of all the rows up to that point. It's not that that is especially harder, it's that I'm hoping to be able to tell the grid how to do the calculating rather than do all of the calculations in my object and just bind the grid to that field.