5 Replies Latest reply: Oct 26, 2012 6:34 PM by LEWIS GOLDSTEIN RSS

    Only display straight table if rows exist

      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.