We are having a peculiar situation where we need to calculating cumulative running totals in fly reducing a certain percentage value(.98). The new row should take the previous calculated value to cumulation.
Below is the sample data set. Here you see 5th row is cumulation till 4th row multiplied by .98, where 6th row should take the result of previous calculation that is 9.8 for cumulation and not 10.
Please let me know your thoughts on this which is our last resort 😊
Rep Month/Year Measure Cumulative result Calculation
Rep1 2017001 0 0
Rep1 2017002 0 0
Rep1 2017003 0 0
Rep1 2017004 10 9.8 (0+10)*.98 = 9.8
Rep1 2017005 10 19.404 (9.8 + 10)* .98
Rep1 2017006 0 19.01 (19.04+0)*.98
Rep1 2017007 10 28.43 (19.01 + 10)*.98
Rep1 2017008 20 47.46 (28.43+20) * .98
Rep1 2017009 6 52.39 (47.46+6)*.98
Rep1 2017010 30
Rep1 2017011 0
Rep1 2017012 0