Discussions

Expand all | Collapse all

Using count with case statements

  • 1.  Using count with case statements

    Posted 06-28-2017 12:44
    I am trying to create a summary variable that counts a set of fields if they are not null or do not contain a specific variable (e.g., "Not Applicable"). Can the count function be used in combination with case or if statements to achieve this?


  • 2.  RE: Using count with case statements

    Posted 06-28-2017 15:56
    What you need to do is move your boolean logic into a checkbox formula field in the child table. Thenm when creating the summary field, all you need to do for a filter is reference that single field as checked/true.