Forum Discussion
Eric Abadie
Apr 20, 2017Copper Contributor
Forecasting formula question
I am using the FORECAST.ETS formula in Excel 2016. I am trying to forecast daily values. The reality is such that I have seasonality and values by day of the week. Every Saturday and Sunday my values are zero while Monday to Friday I have numbers.
How do I use the FORECAST.ETS formula such that it understands my weekends should be zero? currently on weekends it simply gives me some low numbers on weekends but not zeros as it should. see below.
Thanks for your help
Eric
No RepliesBe the first to reply