sub-sammry not working as expected

[kisschef]

I have a problem, something that is probably stupidly simple, and will probably figure out, in time. But, I'm up against a deadline, kind of stumped, and have really spent too much time on this already. I'm hoping someone can help me out. I have a table of transactions, each a purchase or sale of an object. Each transaction has some quantity of objects. Each object has an associated weight, and an associated billing rate (per weight). There 3 categories of object: metal, plastic and other. The base table has an Amount Due field, which is a calculation (unstored, returning a number) which is quantity*rate*weight. In generating an invoice, I want to bill based on a snapshot of the client's current holdings for a specific period. I have created a TO that filters out transactions that occur after the billing period. Then I created a report based on that TO, and sorted it by category and then by part number. On the report, I show Amount Due on each line as well as Summary Amount Due (summary: total of Amount Due). The Amount Due fields seem to be calculating properly, but when I try to get summaries by category, or (grand total summaries) by invoice, each line of the TO that is based on multiple records of the transactions table seems to have the sum of Amount Due on that TO line multiplied by the count of the number of records that were rolled together to make that line.

[GisMo]

How are your sub-summary parts sorted? The field you want to total should be how the sub-summary part is sorted. 

 

I few screenshots would be helpful