12 Replies Latest reply: Sep 10, 2015 7:55 AM by Jonathan Dienst RSS

    Filter help???

    Amit Saini

      Hi Folks,

       

      Below is my requirement :

       

      I would like to implement the following logic (I want to use Category 2 for the split and leave Category 3 reporting the existing data)

       

      Where category 3 is like BEL% then set category 2 = Incident

      Where category 3 is null then set category 2 = Unclassified

        Else set category 2 = Change


       

      I'm trying something like this : 

      =if(match(Category3,'_BEL%'),'Incident',

       

      if(match(Category3,'-'),'Unclassified','Change'))

       

      But it's not working. Kindly help!

       

      Thanks,

      AS