Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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