1 Reply Latest reply: May 22, 2017 9:02 AM by Digvijay Singh RSS

    Count Missing ID

    Pooja Nagaraj

      Hi All,

      I am facing difficulty in building the logic mentioned below:

      If a ID was activated and never deactivated till Today then consider it as active for all Months.

       

      Input:

      Input.png

       

      output:

      Input.png

      In the above output:

      Jul 2012 had 2 IDs 1 and 2 ,therefore  Count(ID)=2

      Aug 2012 have only one ID(i.e. 2).  ID 1 is not updated in Aug  and also it is not deactivated in Jul 2012 .So,i have to count it as activate in Aug 2012 .

       

      Thanks,

      Pooja