set analysis help

[#1]

Hi

I am trying to show the count of a row based on certain criteria. I'm using a text box to show the number.

This is my expression but it does not work, I cant figure out how to do one part of it.

=Count({$<TimeTracker.RequestType={'SR'},{<ServiceDesk.CallRequestNum=TimeTracker.RequestNum>}TimeTracker.ActualCompletedDate)

So I need to count TimeTracker.ActualCompletedDate but only when TimeTracker.RequestType = SR and ServiceDesk.CallRequestNum = TimeTracker.RequestNum.

any help is appreciated

thanks

Alam

[#2 · Accepted solution]

Try this one:

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

If you want to count the distinct ActualCompleteDate, you need to add 'Distinct' in this expression.

Hope this help you.

[jyothish8807]

Hi Alam,

Try like this:

if(time.tracker.requestType='SR' and ServiceDesk.callrequestNum=Timetracker.requestNum,count(Timetracker.actualcompletedate))

Regards

KC

[#4]

thanks both helped