5 Replies Latest reply: Mar 22, 2017 7:29 AM by Sunny Talwar RSS

    Formula in set Analysis

    Priyabrata Das

      Hi All,

      I have a formula like :

       

      ((Count(Distinct {<Period={">=8"},Program ={'S'},Status-={'Absence'}>} STDNUMBER)

       

      /

       

      Count (Distinct STDNUMBER)) * Batch) / # of STDNUMBER  of each batch.

       

      Here Batch is like 2010/2011 format.

       

      So for example : 2011 batch : 20/700, 2012 batch : 5/345  Total : (20/700+5/345)  / 2.

       

      Please help in how to achieve this in set analysis