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

    Conditionally exclude row from a table?

    Stephen Hasson



      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.