Forum Discussion

MeghanJaKa's avatar
MeghanJaKa
Qrew Member
7 years ago

Using count with case statements

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?
Ask about Quickbase functionality
Formulas and functions

1 Reply

Sort By
  • MichaelBarrow's avatar
    MichaelBarrow
    Qrew Cadet
    7 years ago
    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.