How to exclude records using dynamic filter (instead of filtering to include)?

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • Answered
I have a field called "Status" that has many 6 different values (Not Started, In Progress, Complete, ...). "Status" appears in my Dynamic Filters. Is it possible to exclude using the Dynamic Filters? I'd like to simply exclude Complete (as opposed to filtering for Not Started, In Progress, and...). 
Photo of AO

AO

  • 304 Points 250 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

HI,

Build a hard filter inside the report customization interface to exclude the Statuses you do not want. I believe this will limit your dynamic filter to those statuses you do wish to include in the dynamic filter.

Chris

Photo of AO

AO

  • 304 Points 250 badge 2x thumb
Unfortunately that does not fit the business requirement. Users frequently employ many different combinations of dynamic filters (which is why I can't hard code it), but most frequently wish to exclude just one value ("Complete") 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
If there are particular Status which are generally used opposite, then make a field called Complete Y/N and add that as an additional DF.

The formula for that field would be 

IF([Status]="Complete", "Yes", "no")
Photo of AO

AO

  • 304 Points 250 badge 2x thumb
yeah, i was trying to avoid that- sounds like it's my most viable option