I am having a problem getting one cumulative sum for items that were paid for in each month when the only values I have are cumulative. In my record, I have the original balance and the current balance. While original balance does not change, the current balance changes after every payment. You will notice that sometimes more than one payment happens in a month.
I want only the final current balance value for each selected period (Month Quarter or Year).
I also want to use the current balance to subtract from the original balance in order to evaluate the total payments for each month, quarter or year.
My workout here returns wrong values for June and July where more than one payment date is involved