7 Replies Latest reply: Jun 7, 2017 10:13 AM by Monica Labrador RSS

    How to exclude '-' data

    Monica Labrador

      I need to create two categories "In client services" which = Jira ticked number being blank/empty/null and

      Escalated to PD which = a value in the record

       

      Using the following expression:

      if(jira_ticket_number='' or 0 or Null() or '-','In client services','Escalated to PD')

       

      I am still getting '-' values in my dataset, any tips on how to include this in my grouping?

       

      Thank you!

      Screen Shot 2017-06-05 at 4.23.58 PM.png