2 Replies Latest reply on Nov 21, 2018 10:48 AM by Sankar M

    Running sum that resets on a condition?

    Tram Le-Nguyen

      Hi,

       

      I would like to calculate the running sum that resets when the value becomes 0. For example:

         

      DateValuerunning sum
      1-Jan33
      2-Jan47
      3-Jan29
      4-Jan3039
      5-Jan00
      6-Jan33
      7-Jan710

       

      I think I would need to use a table calc for this, but I'm not sure what to use in the "restarting every" drop down. May I have some guidance?

       

      Thanks