Getting a $Value in a Sum Field for 0 value records...

[cinbh]

I'm having a major problem where I have specifically selected from my data set records with 0.00 discount. When the report prints (I have 3 groupings) my Order group has 0.00, my Company group has 0.00 but my product group has the total from the WHOLE data set as though I did not select only zeros.

The data set is based on an Excel sheet database. The field is a sum of discount, not a running total.

Appreciate any help, Thanks
Cin

 

[cinbh]

I solved my own problem by looking at the original formula that some of the sums have been based on unsuppressing the detail data and realized I had selected the wrong field for my query, thus bringing in more data than required.
Cin