I have done this correctly for 7+ years but can't seem to get it right this time. Can anybody spot what I am doing wrong. Images to follow.

I am summing up the columns for each year. I enlarged the field just in case the number was to big to fit, I brought the field forward so it is not behind anything, I copied the previous years total so the formatting would be identical and changed it to the current year. The formulas seem identical for the year.

I think the problem is not the subtotal, but the data in the last row (record). I would guess it is -69849.56, which is too big to display, and makes the subtotal too big also.