Skip to main content
Question

Using count with case statements

  • June 28, 2017
  • 0 replies
  • 39 views
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?
    This topic has been closed for replies.

    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.
    Terms & ConditionsAccessibility statement