3 Replies Latest reply: Apr 9, 2014 1:55 AM by Ramkumar Ramagopalan RSS

    Straight table with input boxes: hide rows that do not match

    Jens Zibell

      Hi,

       

      I have a straight table that shows several fields for product information, and a monetary value as expression (although it is not really an expression, as already calculated during the load)

       

      I now added an input box with two variables to be able to filter for product within that range:

       

           =only(if([TCV Reportet (Produkt).P] >= vMin and [TCV Reportet (Produkt).P] <= vMax, [TCV Reportet (Produkt).P]))

       

      This is working, except for the fact all the products that do not match remain in the list with a value of '-'. How can I filter them to only show rows matching the input box values?

       

      Thanks

      Jens