Using count with case statements

Question

I am trying to create a summary variable that counts a set of fields if they are not null&nbsp;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?

michaelbarrow · Answer

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.

Forum Discussion

Using count with case statements

Related Content

Dynamic Rule - Or statement?

formula help "if statement"

Jinja If statement equals field value

Using Grid Edit to Edit Multiple Records at Once

Using AND with Null values