Skip to Content
0
Former Member
Nov 10, 2008 at 06:12 PM

Supressing Zero value rows

7 Views

Hi all,

I am trying to do the following:

Say I have a query output like this

period 1 period 2 period 3

Material 1 KF1 0 33 0

Material 2 KF1 0 0 0

Material 3 KF1 12 32 45

I want to display only those rows which have values for all the periods. In the above case, I need Material 3 row only. I used the supress zero from query properties and I got this:--

period 1 period 2 period 3

Material 1 KF1 0 33 0

Material 3 KF1 12 32 45

But, I don't need the material 1 row also as it does not have values > 0 for all the periods.

Does anyone have a solution for this?

Thanks.

Help will be appreciated and awarded accordingly.