Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
COUNT(if(INCIDENT_TYPE_ID = 'REPAIR' and ARRIVE_DATE='dd/mm/yyyy',1,0))
hope it heklps
COUNT(if(INCIDENT_TYPE_ID = 'REPAIR' and ARRIVE_DATE='dd/mm/yyyy',1,0))
hope it heklps
That works good for both, but how do i get it to work for just INCIDENT_TYPE_ID?