8 Replies Latest reply on Nov 13, 2018 1:43 AM by DHRITIMAN BANERJEE

    Calculated Field Logic: Remove null in filters for the product which does not satisfy the condition


      Hi Community,


      I need help regarding removing NULL when i show in filters.




      In the above requirement, I do not want LA in Product field and create  a calculated field Product  Category where 'LA' is not taken.

      Calculated Field 2.PNG

      Calcaulated Field2.PNG

      My queries or need suggestions as per the business requirements:

      1)Can you please share  a trick or logic where 'NULL' will not be displayed for 'LA' vaue.

      2)When user select 'ALL', it will  shows all products except LA and 'NULL' for LA  product will not be shown and will not be populated in filter logic.