Forum Discussion

ASullivanFFRASu's avatar
ASullivanFFRASu
Qrew Trainee
8 years ago

In a report, my filters don't seem to be working. What am I missing?

I created a report/table so that only Projects/Project Tasks display those pertainable to the current user. Now I want to modify that report so only projects that are NOT Completed or Cancelled show up. I have set my filters to the following:

Show ALL
- Any condition: Field is the Current User, or Field is the Current User, etc.
AND
- Task Status IS NOT EQUAL TO Completed, or Task Status is NOT EQUAL TO Cancelled.



Report is still showing Projects/Project Tasks that are Completed or Cancelled.



What am I missing?
App builders
Ask about Quickbase functionality
Formulas and functions
    • ChristopherJob's avatar
      ChristopherJob
      Qrew Trainee
      5 years ago
      I came upon this exact same issue that ASullivanFFR asked about.  I have a report that I want to automatically filter for my username and when the "Current Status" of the record is not Completed nor Cancelled.  I solved it by using the suggesting from the 2nd comment in this forum AND by changing the criteria from "is not equal" to "does not contain".

      ------------------------------
      Christopher Job
      ------------------------------