Using count with case statements

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of Meghan JaKa

Meghan JaKa

  • 70 Points

Posted 1 year ago

  • 0
  • 1
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
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.