Filter for at least one field != null

  • 1
  • Question
  • Updated 5 years ago
I'd like a toggle filter (or some way to filter) a table such that it only shows rows where at least one of three text fields has data.

I tried a !=null condition for all three fields on the model, with ORs between them in the condition logic (1 OR 2 OR 3). Then I set a toggle filter to activate all three conditions.

It doesn't seem to have any affect.

Any idea how to accomplish this? Am I doing something wrong?
Photo of Matt Sones

Matt Sones, Champion

  • 32,106 Points 20k badge 2x thumb

Posted 5 years ago

  • 1

Be the first to post a reply!