Hello there,
Below is my source dataset
Date Rejection Days
1/1/2018 0 10
2/1/2018 0 10
3/1/2018 0 10
4/1/2018 1 10
5/1/2018 0 10
6/1/2018 0 10
7/1/2018 2 10
8/1/2018 1 10
9/1/2018 0 10
10/1/2018 0 10
11/1/2018 0 10
12/1/2018 1 10
Running total calculation requirement :
1. calculate running total as rejections are 0
2. once we get rejection divide days by rejection + 1 and reset counter for running total and apply (divide days by rejection + 1 ) to next row
3. repeat both step until we reach last reporting date
Expected result with manual excel formula/calculation.


