3 Replies Latest reply on Dec 8, 2018 3:25 AM by Mahadevan Krishnan

    Filter condition problem

    Swetha J

      Hello all,

       

      I wanted to apply filter condition to get specific set of data.

       

      condition 1:  IF status Id count is greater than 1  and person field is not null  then show data.

       

      condition 2: IF  status Id count is equal to 1  and  (person field is null or person field is not null ) then show data

       

      the data which should be filter is  IF status Id count is greater than 1  and person field is null  then don't show

       

      Below highlighted records should be filtered

       

       

      Attached sample workbook

       

       

      Thanks in advance

       

      Swetha J