However, I want to exclude certain items in the orders, so I had to use a formula to calculate the individual order totals: (qty * unit price). Now I want to sum up the individual totals for each customer, but none of my sums are coming out correctly.

 

I tried just creating a summary of the formula in the group footer, but that is giving me a different total than just the sum of the individual order totals.

 

I have my report grouped by order number, to get the necessary totals for each order, which I will then hide, and then by customer, to show the summaries as totalled by customer.

 

Not sure if I explained that well, but let me know if you can help me!

Thanks!

 

Then I tried using this formula: sum({@order total}, {customer.name}) to sum the order totals for each customer, but the totals come out higher than they should.

 

I tried just doing a summary, and I tried various running totals, but nothing has come out right.