0 Replies Latest reply: Jun 27, 2016 9:49 AM by Tim Forbes RSS

    How do I manipulate my current excpression?

    Tim Forbes

       

      I am currently writing an expression for open tickets entering the month.

       

      my current expression is:

      count(DISTINCT if((isNull(Closed) OR date(Closed)>=MonthStart(today())) and date(Opened)<MonthStart(today()), Number))

       

       

       

      I wish to manipulate this expression as the value should be null for all tickets with a state code that is unequal to 1 and in the date(Closed)>=MonthStart(today())) portion of the code should be for any state as the only thing that matters is that the ticket is open upon entering the current month. The values for all states are listed below with their corresponding state code.

       

      State

      State Code

      Awaiting User Testing

      -2

      Cancelled

      8

      Closed - Approved

      20

      Closed Cancelled

      5

      Closed Complete

      3

      Closed Incomplete

      4

      Closed Skipped

      7

      Contacted user - Awaiting User Input

      -10

      Deployed

      -4

      Open

      1

      Ordered - Awaiting Vendor

      10

      Pending

      -5

      Purchased Awaiting Vendor

      9

      Work in Progress

      2