Why are you grouping it?

trying to create an amortization schedule saved search that shows the total amount for each schedule less amortized amount to get to current prepaid expense balance. by amortization schedule. i was grouping them because otherwise it seemed that the search was duplicating the records for each posting period.

You should be summing but you need to break out those components.