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

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

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.

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

Hi,

For equal to(=)

=count({<TimeTracker.RequestType={SR},ServiceDesk.CallRequestNum = {TimeTracker.RequestNum}>}DISTINCT TimeTracker.RequestType)

For not equal to(-=)

=count({<TimeTracker.RequestType -={SR},ServiceDesk.CallRequestNum -= {TimeTracker.RequestNum}>}DISTINCT TimeTracker.RequestType)

Regards

Neetha

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

=count(DISTINCT{<TimeTracker.RequestType={SR}>} ServiceDesk.CallRequestNum)

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

HI,

How are the Time Tracker and Service Desk tables are related to each other. Are they linked using the Request Number from both the tables. If yes,  then you can use

Count(Distinct {<TimeTracker.RequestType={SR}>} ServiceDesk.CallRequestNum)

Thanks

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

Hi,

Is there a way to say equal to and not equal to?

=count(DISTINCT{<TimeTracker.RequestType={SR}>} ................

not equal try this:

TimeTracker.RequestType={'<>SR'}