suppressing zeros in PowerPlay

[slaforce]

I have a powerplay report that wants to know the number of products counted on a particular day (this is for inventory counts). The report should look like this (the measure is qty)
Product Id
ABC DEF GHI JKL

Date
08/01/03 5 10 3 0
08/02/03 0 0 0 5


The problem is - a product is only counted one time every six months. My product dimension has all the products that exist. How can I get the quantity that was counted on a particular day or month. If I zero suppress - then I will lose the products that were counted that day and just didn't have any quantity.

Any ideas?
Thank you for your help!

 

[BruceReed]

I would suggest that you add a field "Counted" to the database. This would a zero for not counted, and 1 for counted. Then filter on this field and the particular date, and not on the counted quantity.

Hope this helps you.
Bruce