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



      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?