Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a set analysis that I am preparing for a dashboard - I need to get the past four week period from Monday to Friday (not from the current day).
I have the formula:
count({<[SCHEDULE DATE] = {">=$(vLast4WeeksStart)<=$(vLast4WeeksEnd)"},DimSG = {'SS'}>}URN)
using the below variables.
vLast4WeeksEnd=date(if(weekday(Now())='Mon.', now()-1,if(weekday(Now())='Tue.', now()-2,if(weekday(Now())='Wed.', now()-3,if(weekday(Now())='Thu.', now()-4,if(weekday(Now())='Fri.', now()-5,if(weekday(Now())='Sat.', now()-6,if(weekday(Now())='Sun.', now()-7,'Error'))))))),'DD/MM/YYYY')
vLast4WeeksStart=date(if(weekday(Now())='Mon.', now()-28,if(weekday(Now())='Tue.', now()-29,if(weekday(Now())='Wed.', now()-30,if(weekday(Now())='Thu.', now()-31,if(weekday(Now())='Fri.', now()-32,if(weekday(Now())='Sat.', now()-33,if(weekday(Now())='Sun.', now()-34,'Error'))))))),'DD/MM/YYYY')
But this doesn't seem to be working - can someone please advise where I have gone wrong? When I take out the variable part, the rest of the formula is working.
Thanks