Exponential Forecast

[tracycrown]

Dear all

Can someone help to show me an example on how to write a script in expression for exponential foreast by months?.

YearMonth	Sales Volume	Exponential Forecast (0.1)	Exponential Forecast (0.7)
Oct-2014	90
Nov-2014	106
Dec-2014	152
Jan-2015	244
Feb-2015	302
Mar-2015	274
Apr-2015	162
May-2015	194
Jun-2015	312
Jul-2015	359
Aug-2015	215
Sep-2015	126
Oct-2015	94
Nov-2015	125
Dec-2015	147

Thank you very much

Tracy

[settu_periasamy]

Hi,

Sorry for the Delay.. Find attached..

[tracycrown]

Dear Settu

Many thank for your help, at least I know how to create a variable and use if-then logic in script now.

Kindly advise if I have more than 2 factors.  For examples, Exp_forecast 0.1, 0.2 ......1.5 etc,  then if-then script might not be the best method. Is there any command eg. Do while or Max ( ) can be used ?.

Thank you

Tracy