2 Replies Latest reply: Feb 12, 2013 11:58 AM by Chris Young RSS

    Count expression with multiple checks

      Hi

       

      I need some help with an expression im am using for a text object. I have two things in need to check for and i dont really know how to go about this. Basically I need to count items if they have a type of REPAIR and if there is an ARRIVE_DATE. I currently have this:

       

      =COUNT(INCIDENT_TYPE_ID = 'REPAIR')

       

      This I would have assumed would bring me the number or incident with a type of REPAIR however this doest, it somehow brings back the total number of incidents regardless of there type. And what would the syntax be to check for an ARRIVE_DATE in this count.

       

      Thanks in advance