4 Replies Latest reply on Jul 5, 2018 11:06 AM by Jen Miller

    count # of unique Id / status "Completed"

    Eric Denault

      Hello,

       

      I am trying to figure out this calculation filed but it always returns me with 100%

       

      Count (IF [Status] = "Completed" then 1 Else 0 end) / Countd ([National ID])

       

      Tried it the other way around and doesn't work!

       

      I have added what I am looking to recreate.

       

      Thx

      Eric

       

      National Id / Group 1

      GroupTotal population per groupCourse title
      Group 1National Id / Group 1Status = Completed / Group 1
      Group 2National Id / Group 2Status = Completed / Group 2