Set analysis problem

[Anonymous]

can anybody correct this one??

basically this expression shows all calls for previous day on that date, if Monday comes the expression should show on Friday data,can anybody help me out??

Only({1<row_date={'$(=Date(Today()-1))'

}, if(WeekDay='Mon',date(max(row_date-3)>}agentacdcalls))

[Anonymous · Accepted solution]

it will work by using this...

vEndDate =today()

vStartDate =firstworkdate(vEndDate,2)

=Sum({<SalesDate={'>=$(=vStartDate)<=$(=vEndDate)'}>}Sales)