Previous week

[has75042]

I am using this set analysis =Sum({$<[CalendarLink]={'(=vPreviousWeek)'}>}OTHours) to get my previous week data, this expression is not giving me the right result.

My variable is as follows:

=date(CalendarLink-7)

[andrey_krylov · Accepted solution]

Hi, Haseeb.  I think you've missed a $ sign. Try this

=Sum({$<[CalendarLink]={'$(=vPreviousWeek)'}>}OTHours)