Hi All
Hope you are all well and able to help
Apologies if this question has been answered as I was unable to find a similar question
Please can someone advise if it's possible to enter a formula which calculates the variance between forecast and actuals only when actuals are inputted by the user, as we expect the user to forecast out over the year but this formula won't work as it takes all forecasted against actuals which will always be a incorrect variance
Thanks for your help in advance
Hope you are all well and able to help
Apologies if this question has been answered as I was unable to find a similar question
Please can someone advise if it's possible to enter a formula which calculates the variance between forecast and actuals only when actuals are inputted by the user, as we expect the user to forecast out over the year but this formula won't work as it takes all forecasted against actuals which will always be a incorrect variance
Thanks for your help in advance