2 Replies Latest reply on Sep 6, 2017 7:10 PM by Matt Reddy

    lookup day by comparing running counts

    Matt Reddy

      Hello,

      I need some help building a formula for following,

       

      Following data shows no. of records finalised in days.

      example - 905 records finalised in 1 days.

       

      3rd column is running sum.

       

      I need to come up with column 4 and 5.

       

      Finalised in DaysRecords CountRunning Records Count%% on running
      count
      010371037
      19051942
      2909285125%2679.75
      37903641
      48174458
      5909536750%5359.5
      614186785
      71380816575%8039.25
      810279192
      97949986
      1073310719

       

      Requirements -

       

      WINDOW_SUM(SUM([CFY - Count])*0.25) in between "Running Records Count" then i need "Finalised days"

       

      so In need  25% - 2; 50% - 5; 75% - 7

          

       

      work book attached