Forecasting data with input values

[#1]

Hi

Please find the atathced

Hi Anil,

1.want to show the input value Sales growthrate1 in forecasting data means if end user enters a value in particuler year so that it will change according to that.

2.the forecasting line meets the target in some year,want to know that year

means based on Sales Growth rate (input box) variable this will vary.

So want to know how to get that crashdate?

Thanks

Anil

[susovan]

Hi Thiru,

Can you share "sampledata.xlsx"?

[#3]

Hi

Please find the attached QVW file here

Forecasting data with input values

Thiru

[#4]

Have u got my Qvw?

[Anil_Babu_Samineni]

Thiru,

Check your Mail

[#6]

Hi Anil,

I didn't get anything in my mail,can you please forward it agian

Thanks

Thiru

[sujeetsingh]

I can not get you what you need in forecasting?

[#8]

Hi Sujeet,

We can get the forecasting analysis using Lineast_M functions,but

my requirement is

1. end user want to give the growth rate(as a drop down using variable),using end user value the forecasting need to reflect.

2.Sales value also he want to add in some month/year based on that again forecasting need to reflect.

Thanks

Thiru

[Anil_Babu_Samineni]

Thiru,

Check the Attachment.

[Anonymous]

Hi Thiru,

You need to include this variable for growth rate in your expression. For eg:

sum(sales)*(1+ vGrowthrate)

Best regards,

Kaveri