Count expression with multiple checks

[#1]

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

[alexandros17 · Accepted solution]

COUNT(if(INCIDENT_TYPE_ID = 'REPAIR' and ARRIVE_DATE='dd/mm/yyyy',1,0))

hope it heklps

[#3]

That works good for both, but how do i get it to work for just INCIDENT_TYPE_ID?