I had a thought as I was writing my reply and sure enough, I had "sum" checked on the fields. So I was summing the sums before. I could have sworn I looked at that before. But I've been switching things around all day and must have missed it. So I put the sum where it belongs and voila!

You have my eternal gratitude.

Michelle


>Hi Michelle,
>
> If the report is using the value from the last detail band, doesn't that mean that the report variable you're using doesn't have the SUM option checked in the Calculations?
>
>Gavin...
>
>>I figured out why my report was behaving so wacky. Instead of using the value that each report variable has in the group footer, it's using the value it had last in the detail band.
>>
>>So my new question is, how do I total across if report variables won't work. I need to take the sum of all the margins on the invoice and divide it by the sum of all the extended prices on the invoice.
>>
>>And then I need to do the same for the sums of all invoices for the salesperson, and again for the grand total.
>>
>>Any ideas?
>>
>>Thanks,
>>
>>Michelle