3 Replies Latest reply: Nov 25, 2014 12:33 AM by Alam Nizami RSS

    set analysis help

    Alam Nizami

      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