Subtotal of a formula

[byteofram]

Ok...here is the problem...I have a report that gives the invoice amount by multiplying the qty_shipped by unit_price. This is done for each customer order, and what I would like to do is total all the invoice amounts for a customer. This seemed easy enough, but when I add a subtotal using the invoice amount formula, it gives me really high numbers, almost like it's adding all invoices from all customers. I can find a pattern to the totals, so any help would be appreciated!

 

[rosemaryl]

Dear Byteofram:

Do you have your report grouped by customer?

I would do this:

Group1 Customer
Group2 Invoice

Now you can insert total by invoice and Sum Invoices by Customer.

Hope this helps,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.