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

    DHRITIMAN BANERJEE

      Hi Community,

       

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

       

      cALCULATED fIELD.PNG

       

      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.

       

      Regards,

      Dhritiman