Forum Discussion

Eric Abadie's avatar
Eric Abadie
Copper Contributor
Apr 20, 2017

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

Resources