Calculation / Summary help
I am trying to calculate a field occurrence in conjunction with another field occurrence.
For instance, I have a "Status" field with a check mark option of "Active"
and a "Study" field with a check mark option of "yes"
I want a count of all patients that both have a status of active and a yes to study.
Every time I do a calculation field and use the count function, it only allows me to enter one field and no parameters.
Do I need to use ExecuteSQL? and if so, help with the SQL code to write.
I want to display this ever changing count on an admin layout. help?