1 Reply Latest reply on Oct 17, 2018 7:57 PM by Josh Ciszek

    FIXED LOD + Count based on If And

    Josh Ciszek

      OMG...What am I missing here?  This seems so basic, but I can't seem to get the right result.  Here is the source data...

       

           

      ClientIDProgramIDScoreDR
      123411
      123532
      456401
      456522
      456633
      999521

       

      I just want to count, for each ClientID, how many Actionable Items there (i.e. every occurrence where DR = 1 and Score >=2).  I seem to only be getting the number or rows per Client ID.

       

      The expected result should be ClientID 123 = 0, ClientID 456 = 0 and ClientID 999 = 1

       

      Picture1.png