Forecast Function in Anaplan
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:
- 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.