Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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