4 Replies Latest reply: Dec 23, 2014 4:22 AM by Yevgeniy Popov RSS

    Set analysis help: equal to and not equal to at the same time.

    Alam Nizami

      Hi

       

      I am trying to add to this expression which works. It counts the service desk tickets if there is a identical ticket number in time tracker. But I want it to count those and even if there is no identical ticket number in time tracker.

       

      Here is my code: =count(DISTINCT{<TimeTracker.RequestType={SR}>} if(ServiceDesk.CallRequestNum=TimeTracker.RequestNum,ServiceDesk.CallRequestNum))

       

      How can I make it do both in this expression? Is there a way to say equal to and not equal to?


      Thanks,


      Alam.