Forecast Function in Anaplan

Options
roshinrasheed
roshinrasheed Member, ALL USERS, Partner, Certified Master Anaplanner, Certified Model Builder Posts: 2 Certified Master Anaplanner
in Planning & Modeling

Hi team, 

 

Can i know if we have an equivalent  function for forecast() from excel in Anaplan. In Excel we have 

Excel FORECAST function

The FORECAST function in Excel is used to predict a future value by using linear regression. In other words, FORECAST projects a future value along a line of best fit based on historical data.

The syntax of the FORECAST function is as follows:

FORECAST(x, known_y's, known_x's)

Where:

  • X (required) - a numerical x-value for which you want to predict a new y-value.
  • Known_y's (required) - an array of known dependent y-values.
  • Known_x's (required) - an array of known independent x-values.

Regards

Roshin Rasheed 

Tagged:

Comments

  • arti.kalekar1
    arti.kalekar1 Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hello @Misbah ,

     

    I have a requirement for a demand planning use case. Customer would like to see a 1) simple moving average forcast, 2) double exponential smoothing, 3) triple exponential smoothing. And finally Anaplan should identify the best fit forecast based on the above three. 

     

    Could you guide please on getting the best fit part. 

     

    Regards

    Arti

     

     

Categories