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

    Running calculation

    Melody H

      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