Skip to Content
0
Former Member
May 05, 2005 at 07:01 PM

Suppressing record with no data

23 Views

Hello Gurus,

I have a query with ID's and key figure values. I don't want to see the ID with key figure values '0' or if they are blank. How do I suppress the row altogether.

Ex:

ID Num Den Val

123 1 1 1

234 0 0 x

345 x

In the above example, I don't want to see either second or third row, so how do I hide this rows.

Thanks,

Anjali