Forecasting with Zero's

[stevie2612]

Hi,

We have Forecasts with Sprodic demand that we are trying to show patterns but because of the Zero's i dont know how to do.

Below i have a customer who in the last two years has bought in July and January, i want a formula to predict from past buying of July and January and show or suggest the demand in these months. Any idea how i can do this?

Thanks

 

[Saba Sabaratnam]

HI

You could use Filter function to get data with more than zero

To do this, enter the following formula in G2

=FILTER($A$2:$B$37,$B$2:$B$37>0)

Then select the data and Click on Forecast sheet and set Forecast End to 29 Feb 2024 as highlighted in yellow.

You will get this result in another sheet.

Kind regards

Saba