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

Compare This Year and Last Year sales

Hi

We have some sales reports where we compare sales of this year to sales of last year. Eg: sales of week 10 2012 to sales of week 10 2011.

But as this year is a leap year, meaning we have 53 weeks, how can we compare WK 53 2012 to 2011? As 2011 does not have WK 53.

Please assume the below:

When I run the report on week 53 of 2012, I want to compare the sales with week 52 of 2011 ( same is true for MTD, YTD) . We have customer exit variable which is working fine till now( This year sales to Last Year sales with an offset on the year), but I doubt it how it will work when we get to WK 53.

Is there any work around.

Thanks

Kedar

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2012 at 04:26 AM

    Hi Mr. Kedar,

    You have to incorporate of leap year YTD & MTD logic in Variable Exit. It has only one day diffirence in four year ,can be easily incorporate in variable exit.

    Regards,

    Anand Mehrotra.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 22, 2012 at 11:05 AM

    Hello,

    Sales for 532010 will be blank , as we do not have week 53 in 2012.

    Thanks,

    Vinay

    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.