1 Reply Latest reply on Sep 16, 2016 3:09 PM by Kaz Shakir

    How do I filter a multiple value field without several clicks

    Chrissy Scott

      Hi All,

       

      I have a field that lists impacted lines of business. So for example, ticket 1 impacted LOB1, LOB2 and LOB3.

       

      I need a way to filter the ticket list by one LOB at a time. I tried using the contains function:

       

           IF CONTAINS(LOB, "LOB1") THEN "LOB 1

           ELSEIF CONTAINS(LOB, "LOB2"" THEN "LOB2"

           ... END

       

      This won't work because if one ticket impacted LOB1 and LOB2, the formula only counts in LOB1 because of the order of the formula.

       

      Is there any way to make a calculated field that will work for this? I can use a wildcard match filter, but that's not a very positive customer experience. Thoughts?

       

      Thanks,
      Chrissy