cancel
Showing results for 
Search instead for 
Did you mean: 

Suppressing record with no data

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Anjali,

You can create a condition on your KF to display only greater than zero. This will not display the blank rows then.

Hope this helps...

Former Member
0 Kudos

Great!!

Thanks,

Anjali

Answers (0)