Generating forecast data

[#1]

Hi Guys

I have scenario

I have a data like below

Year          Sales

2011          234

2012           456

2013           342

2014           476

2015           435

2016           982

from

2017           2016 sales value+(2016 sales value*1%)

2018           2017 sales value+(2017 sales value*1%)

2019          2018 sales value+(2018 sales value*1%)

This percentage value is dynamic it is coming from my input box      Sales growth Rate

And i want to this calculations in my front end not in script(since the variable value will be selected by end user).
So i want to do this in my chart expressions.

Is there any way to this.

Please do the needful

Thanks

Thiru

[#2]

HI Sunny,

to adding to the above my data is not having years it is monthly based records

like 2016-JAN-01

      2016-FEB-01

      2016-MAR-01

      2016-APR-01

      2016-MAY-01

      2016-JUNE-01

     2016-AUG-01

beacuse you mention in the code it is max(rowno()-year(today()), so here 230-2016 but my scenario  230-2016-JULY-01 may not work

Please do the needful

Thiru