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

[sunny_talwar · Accepted solution]

Try this expression:

=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)

Where Column(1) is your first expression

[#3]

Hi Sunny

Thanks

It's working

Thiru

[#4]

Hi Sunny

Is there any other way to do directly with out if and with out column() functions

Now

=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)

I need

= Above(Sum(Sales)) * 1.1)

Thiru

[sunny_talwar]

You want the same result, but you want to do without using if and Column() function?

[sunny_talwar]

Here is another method you can try:

RangeSum(Sum({<Year = {"$(='<=' & Year(Today()))"}>}Sales),

Above(Sum({<Year = {"$(='>=' & Year(Today()))"}>}Sales), RangeMax(RowNo() - Year(Today()) + Min(TOTAL Year) - 1, 1)) * pow(1.1, RowNo() - Year(Today()) + Min(TOTAL Year) - 1))

[#7]

Hi Sunny

How to use

this

=If(Year <= Year(Today()), Sum(Sales), Above(Column(1)) * 1.1)

in text box objects?

Thiru

[sunny_talwar]

What number/numbers do you want to see in the text box?

[#9]

Hi Sunny

It's not numbers based on this values i need to get that date,As per our old discussion for crash date actual vs target

here using this i need to get that Crashdate and Actual date.

action date on chart based on max value

Regards

Thiru

[#10]

Hi Sunny

I have created a  variable which is =Year(Today)

so wherever you used Year(Today) can you please replace with V_YEAR variable and try it

Please do the needful

Regards

Thiru