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 : 





      But it's not working. Kindly help!