2 Replies Latest reply: Apr 16, 2018 3:17 AM by Salvatore Mantaci RSS

    Sum If Count in Misure Expression

    Salvatore Mantaci

      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_NumberCall_Request_ID
      Inc001Call_re01
      Inc001Call_re02
      Inc001Call_re03
      Inc002Call_re04
      Inc003Call_re05
      Inc003Call_re06
      Inc004Call_re07
      Inc004Call_re08
      Inc005

      Call_re09

      The result should be 2

      Can someone help me with this matter?