9 Replies Latest reply: Jan 31, 2018 3:13 AM by Stephen Hasson RSS

    Conditionally exclude row from a table?

    Stephen Hasson

      Hi,

       

      If I have

       

      -Part Number

      - Description

      - Onhand-Qty

       

      as columns in a table, how do I prevent rows where the 'Onhand-Qty' = 0 from being shown?

       

      I've tried Aggr function, If statement etc, but can't figure it out.......

       

      I can suppress the '0' and get '-' instead, but I can't get the rows to be excluded.

       

      Thanks.