1 Reply Latest reply on Jun 6, 2018 7:46 PM by Shinichiro Murakami

    Counting repeat learners by fiscal year

    Valdis Tomsons

      Hi,

       

      I would like to calculate how many students in a given fiscal have been a student in a previous fiscal year. I want to only count those with a Active (A) status but I seem to be considering each status when counting the programs of an individual student.

       

      Can someone help me? I want to show how many repeat learners in 2016, 2017, 2018.

       

      Thanks for any help you can provide. I have attached my workbook. It is the "unique Learners" sheet.

       

      Val