0 Replies Latest reply: Feb 29, 2016 2:16 AM by Silambarasan M RSS

    How to count new entered Id and existing removed id based on month

    Silambarasan M

      Eg:

       

        one month :ID -1,2 are enter,so count is two

        two month: Id-3 are enter,so count is one

      three month: Id-2 removed ,so count of removed id is 1

      four month : id-1 removed and id-4 enter so 1 & 1 which means count of enter id and count of removed id

       

       

       

       

      output table:

       

      Date  count

      1-jan  2

      1-feb  3

      1-mar  1

      1-apr   1  & 1

       

      tresescohicbpnziadmohd1

       

       

      Message was edited by: Silambu