4 Replies Latest reply: Sep 14, 2014 9:52 AM by Kalpesh Jain RSS

    Cumulative open days and count

      Hi ,

      please help me with this


      Imagine that Notification No 1 was 2 days open end of Aug, and  Notification No  2 was 1 days open.

      Sum is 3 days open Aug.

      2 open Notification

       

      Imagine that Notification No 1 was closed in Sep, Notification No 2 is still open end of Sep, but there was 1 new Notification created middle of the month.

      End of Sep  the situation is:

      Notification No 1: not be taken into consideration anymore

      Notification No 2: 31 days open

      Notification No 3: 15 days open

       

      Cumulative open end of Sep  is 46 days.

      2 open notification

      Similar if completion date is not present it should be considered as open 

       

      Notification NoCreated on DateCompletion by Date NewTotal No of Days OpenSales Divition
      18/28/20139/30/20133310
      28/30/201310/30/20136110
      39/15/201311/30/20137610
      410/29/201310/30/2013120
      512/31/20132/28/201425720
      61/29/2014 22820
      71/31/20142/28/201422610
      82/28/2014 19820