Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have the following expression to choose only three programs for clients. It generates no error message but won't get me any results...
What is wrong with the following expression?
=avg({<[Begin Date]={">=2022-01-01"},[Program]={"='Swimming'"}>} [LengthOfStay])
After I get this working, I will add "Judo" into the program set. What should the expression be for that?
Thanks,
Deguza
@deguza Please use the below expression
=avg({<[Begin Date]={">=2022-01-01"},[Program]={'Swimming'}>} [LengthOfStay])
If you want to add "JUDO" then you may use the below expression.
=avg({<[Begin Date]={">=2022-01-01"},[Program]={'Swimming','Judo'}>} [LengthOfStay])
@deguza Please use the below expression
=avg({<[Begin Date]={">=2022-01-01"},[Program]={'Swimming'}>} [LengthOfStay])
If you want to add "JUDO" then you may use the below expression.
=avg({<[Begin Date]={">=2022-01-01"},[Program]={'Swimming','Judo'}>} [LengthOfStay])
Thank you!
Deguza