AnsweredAssumed Answered

Calculation / Summary help

Question asked by AndyGriffith on Aug 29, 2014
Latest reply on Aug 29, 2014 by philmodjunk


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?