Straight Table - hide rows with null values

[exfosteve]

I have a straight table set up, and I'm trying hide the rows with a null value in the AvgTime01 dimension.  I can't figure out how to do this. I've attached the QVW/QVD that I'm using. 

Any help on this would be great.

thanks,

[sunny_talwar]

Make your second expression to be 0 when the first one is null... also make sure to select the total mode of Average to see the correct sub-total

If(Len(Trim(avg(Timer01))) > 0, Avg(Timer02))

[sunny_talwar · Accepted solution]

Another way to do this would be to use search string in the set analysis

Avg({<system = {"=Len(Trim(avg(Timer01))) > 0"}>} Timer02)

[exfosteve]

Works like a champ.  Thanks