Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
The following expression shows data based on any data for when the roster date=today.
(Count({<
Sickness_SMART.Roster_RosterDate={'$(=Today())'}
>} [Sickness_SMART.Full Name]))
I want to create the same expression for this day last week, but it returns zero. See below
(Count({<
Sickness_SMART.Roster_RosterDate={'$(=Today()-1)'}
>} [Sickness_SMART.Full Name]))
Any thoughts why it doesn't work
Try like: (Count({<Sickness_SMART.Roster_RosterDate={'$(=Date(Today()-7))'} >} [Sickness_SMART.Full Name]))
Try like: (Count({<Sickness_SMART.Roster_RosterDate={'$(=Date(Today()-7))'} >} [Sickness_SMART.Full Name]))
hi
this is why your expression is not working.
1: You have done today()-1 instead of today()-7
2: today()-7 will return you a number not a date
3: Change that number to date by date() function
4: Make sure all your dates are in same format.
The solution is already provided by tresesco and should work
I realised typed 1 on my question, but I meant to type 7.
Thanks
Phil