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.