Hi,
I have a requirement to create a macro for calculating Average forecast. Avg forecast Calculation: sum of weekly qty / number of weeks.
For eg:-
W1
W2
W3
W4
W5
0
200
423
0
200
Number of weeks considered are from W2 to W5=4 weeks excluding the weeks which have no fcst & considering the week which have fcst till total horizon in defining the number of weeks.
Can you explain the steps for developing the macro?
Thanks,
Rajeev