Hi Experts
we have a requirement where a weekly macro to restrict to 3 months
we have 2years horizon but for first 3 months we are using X logic and remaining months Y logic . this works absolutely fine in monthly view . in weekly view when we use 12 iterations (3 months ) since the periods roll forward , logic which we are using for 3 months is going beyond 3 months. please suggest some logic if you have come across.
Thanks Raja
For the 2 years horizon how much is in weekly and how much is monthly. Please provide the split.
Hi Ayan
Entire two years is in weekly buckets. For X logic it should consider only the weeks in first three months when we roll forward . for example if we are in start week of march then it should consider 12 weeks when we go to next week it should consider 11 weeks .....
Thanks
Hi,
As some months are of 4 weeks and some are of 5 weeks.
To handle this situation, I guess Custom Macro or Program is required.
regards,
Sachin
Add a comment