Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello to All!
I want a measure that counts only Incident_Number where the number of ACT_Call_Incident_Relationship.Call_Request_ID is = 1.
I wrote in this way
Sum(If(Count([ACT_Call_Incident_Relationship.Call_Request_ID])=1 and Count(DISTINCT Incident_Number)=1,1,0))
But I get an error in the expression.
Incident_Number | Call_Request_ID |
Inc001 | Call_re01 |
Inc001 | Call_re02 |
Inc001 | Call_re03 |
Inc002 | Call_re04 |
Inc003 | Call_re05 |
Inc003 | Call_re06 |
Inc004 | Call_re07 |
Inc004 | Call_re08 |
Inc005 | Call_re09 |
The result should be 2
Can someone help me with this matter?
May be this
Count(DISTINCT {<Incident_Number = {"=Count([ACT_Call_Incident_Relationship.Call_Request_ID]) = 1"}>} Incident_Number)
Thanks a lot!!!