DP Macro

[former_member309586]

Hi Gurus,

We have 2 months history in daily bucket  and my we wanted to generate forecast for

Monday Forecast = Average of (only Monday 4 weeks back )

Tuesday Forecast= Average of past 4 Tuesday history

Wednesday Forecast = Average of Past 4 Wednesday history

Thursday Forecast = Average of past 4 Thursday History.

Friday Forecast = Average of Past 4 Fridays history

Can anyone help me in writing Macro for the above logic?

It will be helpful

Thanks in advance

Regards,

Rajesh

[former_member309586 · Accepted solution]

done

[Former Member]

Hi Rajesh,

Could you please share the logic you used . It would be very helpful as i am also trying to crack the same.

Regards

Suptha