13 Replies Latest reply on Sep 11, 2019 12:17 PM by Deepak Rai

    FIXED LOD Calculations

    NAYANA MADHEKAR

      Hello,

       

      1.PNG

      I have data for an LMS. Year of completion is 2017. Email address of employee. Module names and

       

      If Module Passed = 1 (Completion Status)

        Module Failed = 0

      Module Passed X times (more than 1) = 2,3,4,5.... (Sum of Completion Status)

       

      For the 4th Module.. the user completed it 3 times...

       

      I need a count of all Users that completed Module X times (more than just once)

      I put the formula for Xtimes count as:

       

      (If SUM([Completionstatus])>=2

      then

      1

      ELSE

      0

      END

      )

       

      Now.. I want to remove all the fields.. and only have the count for user completed Module X times to show up... I am guessing I'd need a FIXED cal?

       

      The result should be such

      2017    1 user. (in the screenshot)

      2018    XXX

      2019   XXX

       

      { FIXED [Email], [Contentname]:[Xtimes Count]}???

       

      Thank you very much for helping in advance.