7 Replies Latest reply: Jun 26, 2015 6:10 AM by Narendra Reddy RSS

    Hide lines based on formula

    Günter Angerer

      I have a straight tabe with some dimensions like order number, customer name etc. and some formulas that calculate the produced quantity, the delivered quantity and the ready for dispatch quantity. The dispatch quantity is simply "produced minus delivered". This results in a table that looks like this:

      Table1.PNG

      I want to get rid of all lines in this table where the "Ready for dispatch" column has a "0" value:

      Table2.PNG

      Is there a nice way to do this in the properties somewhere? I tried my luck with the surpress zero values, but this did not work out the way I wanted.

       

      Many thanks for your help!

       

      Günter