Calculate a row value based on previous row

[Zakir Sharief]

Hi,

I have a yearly data and have a fix value for a base year, this value has to be extending based on certain percentage every year. The bigger challenge is to extend the value based on the previous year value. It is very simple is excel, please see the example data below.

I am unable to achieve the similar calculation in Spotfire, could you please help in performing this calculation in Spotfire.

 

 

 

Year

Percentage

Value

Calculation in Excel

 

 

2011

 

3,000.00

 

 

 

2012

8%

3,240.00

`=C2*(1+B3)

 

 

2013

7%

3,466.80

`=C3*(1+B4)

 

 

2014

10%

3,813.48

`=C4*(1+B5)

 

 

2015

5%

 

 

 

 

2016

5%

 

 

 

 

2017

6%

 

 

 

 

2018

8%

 

 

 

 

2019

9%

 

 

 

 

2020

6%

 

 

 

 

2021

9%