Year Over Year Comparison ..

Wed, 07 Aug 2013 20:21:50 GMT

Hello Guys, I need Help with calculating Year over Year Sales But I also need the last year's date should be a working day.

For example

Aug 5th 2013 is Monday

Aug 5th 2012 is Sun

So if the same date falls on a weekend then i want the next weekday Aug 6th 2012 selected from the previous year .

Re: Year Over Year Comparison ..

tresB — Thu, 08 Aug 2013 07:13:38 GMT

Try like this:

Expression: =Sum({<Date={'$(=Date(Addmonths(Max(Date),-12)+vWeekend))'}>}Sales)

where,

vWeekend=Pick(Match(Num(Weekday(Addmonths(Max(Date),-12))),6,5) ,1,2)

PFA