2 Replies Latest reply: Apr 25, 2014 7:04 AM by Felim Shanaghy RSS

    How to calculate the cummulative sum of values between 2 dates in expression ?


      I want capture the cummulative sum of say Passed values between 2 dates (where one is in dimension) in expression

       

      For eg: day 1: sum(passed) w.r.t latest excecuted time

      day2: sum of passed for day 1 as well as day2 w.r.t latest excecuted time

      day3: sum of passed of day1, day 2, day3 w.r.t latest excecuted time

       

      In aggregation I want give inbetween function of those 2 dates

       

      Sample: Input data

       

      test case1.42.43.44.45.46.47.4
      apassed
      passedfailedpassed


      failedpassed
      b

      passed


      failed
      failedpassed
      c
      passedfailed
      passedpassed

      passedfailed
      dpassed





      skipped

      e

      failedfailedpassedpassed
      failed

      fskipped


      passedpassed



      gpassed



















       

      Required Output:

       

      Daypassedfailedskipped
      7.4421
      6.4421
      5.46
      1
      4.47

      3.4331
      2.4421
      1.44
      1