Skip to Content
0
Former Member
Oct 25, 2012 at 08:51 AM

Avg forecast calc

37 Views

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