Forum Discussion
alexw94
Aug 23, 2023Copper Contributor
Help with year end forecast figure based on 3 years historical data and current year run rate?
Hello, forecasting data is something new for me so I would like a bit of a pointer on how I can achieve a realistic forecast with a given set of data. I have the data in a screenshot. So what I a...
HansVogelaar
Aug 23, 2023MVP
In the attached workbook, I have reorganized the data into a single timeline, and used the FORECAST.ETS function to predict the values for the coming months.