Only display straight table if rows exist

[#1]

I have a straight table with 3 columns, the first 2 are dimensions, and the third is comprised of the following expression:

     sum(if(MDISKAVG >= vWarnThreshold or PDISKAVG >= vWarnThreshold,1,0))

I would like to know how to hide the table if there are no rows, i.e, when column expression calculates no values over threshold.  I understand I need to put an expression in the Show Conditional in the Layout Tab, just not sure what that expression should be.  Initial thought was similar expression to column 3 expression, but that one is at a per column level, not total of column.

[MayilVahanan]

Hi

Can you provide a sample file?

[Anonymous]

Lew,

But - did you try it?  Logically it should work.  When this expression is in show condition, it is calculated over all data in current slections, dimensions don't matter.

Regards,

Michael

[#4]

The straight table looks something like this:

SEGMENT	DISK	sum (if(MDISKAVG >= vWarnThreshold or PDISKAVG >= vWarnThreshold,1,0))
14	$FC0101	2
9	$FC9110	2
11	$FC8101	5
12	$FC2222	5

[MayilVahanan · Accepted solution]

Hi

Agree with mr.Michael Solomovich.

From this attached file, you can see, if sum(allowed) is less than certain value, you can hide the sheet.. but its based on selection not overall..

[#6]

Mayil and Michael,  you were both right.  I think when I first tried this I may have formed the expression incorrectly.

This one worked:

=if(sum(if(MDISKAVG >= vWarnThreshold or PDISKAVG >= vWarnThreshold,1,0))>0,1,0)

Thank you much!

Regards,

Lew