Grand total of running totals error

[LMRollins]

I have a report that works great until I try to get rid of some records in group selection. Here's what I have:

I group by Part ID with running totals for Qty on Hand, Usage Qty, Excess Qty, Excess Value, and Total Amt for QOH. This all works fine but I need to be able to have any part that has a zero amount for usage qty to drop out of the report. I also need to drop from the report any excess qty that is a negative value.

I can use group selection and they will disappear but when I start trying to total what's left, as you know, the total includes even those items suppressed by group selection.

I need help desperately. I've got to get this report working by next month. Can anyone tell me how to total this report with it picking up the values I need dropped?

 

[Roadkill150]

Hello,
is it possible to filter these out in the record selection? If not, then set up your running total to be conditional where it does not count the fields when your usage qty=0
-Bruce Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com