Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello/Hola/Namaste/Dia Dhuit,
I wish to have a set analysis expression which has the and command where the field admission is between the two variables. After some searching, I have come up with the following but with no success. The results appear to not be filtered by the first variable.
Count({< caretype={'N'},admission = {">=$(=date((vMondayofLastWeek)))"} > + < admission = {"<=$(=date((vSundayofLastWeek)))"}, referredby = {'101021889','101030294'} >} distinct rescare_Id)
Any ideas?
Dank u,
Matt
Hi,
You can use like this,
Count({< caretype={'N'},admission = {">=$(=date((vMondayofLastWeek)))<=$(=date((vSundayofLastWeek)))"}, referredby = {'101021889','101030294'} >} distinct rescare_Id)
Or
Count({< caretype={'N'},admission = {"admission >=$(=date((vMondayofLastWeek))) And admission <=$(=date((vSundayofLastWeek)))"}, referredby = {'101021889','101030294'} >} distinct rescare_Id)
Celambarasan
Hi,
You can use like this,
Count({< caretype={'N'},admission = {">=$(=date((vMondayofLastWeek)))<=$(=date((vSundayofLastWeek)))"}, referredby = {'101021889','101030294'} >} distinct rescare_Id)
Or
Count({< caretype={'N'},admission = {"admission >=$(=date((vMondayofLastWeek))) And admission <=$(=date((vSundayofLastWeek)))"}, referredby = {'101021889','101030294'} >} distinct rescare_Id)
Celambarasan
Hi,
Combine the two expressions in one set. I haven't syntax checked this but it would look like this:
Count({< caretype={'N'}, admission = {">=$(=date((vMondayofLastWeek)))<=$(=date((vSundayofLastWeek)))"}, referredby = {'101021889','101030294'} >} distinct rescare_Id)
Regards,
Stephen
Thanks Celambarasan and Stephen. Easier solution than I thought!