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

    count # of unique Id / status "Completed"

    Eric Denault



      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.





      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