6 Replies Latest reply: Dec 30, 2014 1:36 PM by Ivan Trayanov RSS

    Running Total

      I have a data set similar to the below table.  For every 'Date' and 'Key' I have a 'Residual' value.  This residual value will be the same for each key.  However, I am having some issues with calculating the 'ResidualTotal' field.  This field should be a running total of the residual values for each key.  I know how to incorporate the rangesum/above function (i.e. rangesum(above(sum(residual),0,rowno()))) but I do not know how to implement it in this scenario when I do not want it by row number and I cannot replace rowno() with 'Date' and 'Key'.

       

      DateKeyResidualResidualTotal
      1/1/2014A2020
      1/2/2014A2020
      1/3/2014A2020
      1/4/2014A2020
      1/5/2014B90110
      1/6/2014B90110
      1/7/2014B90110

       

      Any help would be greatly appreciated.