Compare This Year and Last Year sales

[Former Member]

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

[vinay_lohakare5]

Hello,

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

Thanks,

Vinay

[Former Member]

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.