Hi guys,
I'm trying to build a calculation (running calculation) from this table (+parameter).
FYI: these numbers below are running total sum
I would like to make the first row 0 (that we input in the parameter) as a base and the following numbers will be calculated based on the base row (base number + 1/base number, .second date_diff/base number, third date_diff/base number and so on)
for example (August & September):
row 0 is the base number (based on the parameter that we choose). The following number should be calculated like
August
row 1) 1.86/0.9 = 2.07
row 2) 2.38/0.9 = 2.64
row 3) 2.89/0.9 = 3.21
row 4) 3.47/0.9 = 3.86
and so on
September
row 1) 1.87/1.09 = 1.72
row 2) 2.34/1.09 = 2.15
row 3) 2.75/1.09 = 2.52
row 4) 3.15/1.09 = 2.89
and so on
and I want to have a table with the output like
and if we choose row 1 (date_diff 1) as the base number, it will be calculated as above but based on the value in row 1.
Thanks in advance,
M
Hi Melody,
Find the attached workbook and data source
After selecting 0
After selecting 1 :
Hope this helps kindly mark this answer as correct/helpful so that it will help others
BR,
NB