No, it's not checked. That's the other VFP oddity I discovered after much frustration. If I check "sum", which seems perfectly logical if I want a sum, I get an astronomically high number. If I check "nothing", I get the correct sum.

So I can't check it or my totals will be orders of magnatude too high.

Thanks,

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