0 Replies Latest reply on Aug 12, 2013 12:59 PM by Devon Embery

    Running_Sum with NULL Date

    Devon Embery

      A variation of this question has been asked but nothing seems to fit my situation exactly. I have 2 data sets that join on date, where data set 1 has actuals and data set 2 has budget. I'd like to do a running_sum on budget but whenever data set 1 has a NULL date (so cannot join to data set 2) the running_sum re-starts the calculation.

       

      How can I get the calculation to aggregate the value whether or not the dates match? Workbook attached.

      running_sum.png