Forum Discussion
How to calculate Forecast accuracy
Hi, I've been trying to get my head around how to calculate a forecast accuracy. Here is how I usually set up a simply formula in excel: First I calcula...
Hello
what if the your data are not in the same table ? you can use the SUMX function
I got one table with forecasts per month per product
one table with sales per month per product
one quick measure to calculate per row the gap / delta
one measure to measure the accuracy at row level.
But i run into same issue to agregate at region or country level
i keep looking. if I found i will share with everyone. In the meantime, if you all ready have the solution, thanks
Hello
Did you find the solution ?
Best regards