Year Over Year Comparison ..

[#1]

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 .

[tresesco]

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