1 Reply Latest reply on Apr 23, 2018 6:51 AM by Zhouyi Zhang

    Looping Calculation

    Mithun Shanmugam

      In my below example, I have two open issues. Their original due date is when the issue to get close. For some reason, they revised the closure date in future.

       

          

      IssuesReporting DateOriginal Due Date Actual Closure Date
      14/1/20184/30/20186/30/2018
      24/1/20185/31/20185/31/2018

       

       

       

      For the issue#1, 4/30/2018 < 6/30/2018 then I need to add the counters from the reporting month until Actual Closure Date satisfies. Then use the "total Count" to plot the line graph.   

       

           

      Expected Data:

      Reporting Month - 4/1/2018Actual Closure DateActual Closure DateTotal Count
      6/30/20185/31/2018
      April112
      May112
      June1 01

       

      Best!