1 Reply Latest reply on Aug 9, 2018 4:55 AM by Naveen B

# Running calculation

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.

M

• ###### 1. Re: Running calculation

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