Skip to Content
author's profile photo Former Member
Former Member

How to make weekly macro limit to months

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Feb 21, 2018 at 10:30 AM

    For the 2 years horizon how much is in weekly and how much is monthly. Please provide the split.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2018 at 12:35 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 28, 2018 at 08:49 AM

    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
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2018 at 01:47 PM

    i am looking for the logic.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.