Forum Discussion

kbarry's avatar
kbarry
Qrew Member
2 days ago
Solved

'Equal to' 'Not Equal to" not opposites

I am trying to filter a report and am struggling to get the inverse of the if/then to show properly.

I have tested the 'equal to' formula and it is working properly. i.e. I set a filter to be equal to that word so it only pulls records with that word in the field I am referencing.

However, if I want the inverse of that report. i.e. I want all the records that do not contain that word to pull on the report however the inverse which I believe should just be switching the 'equal to' to 'not equal to' is not filtering the report at all. even though I have told the report to show me words not equal to the value I've entered are still pulling to the report. 

I can make a work around with multiple 'equal to' lines. I just believe that selecting the inverse of equal to should pull the records properly. 

TIA,

Kbarry

reports

4 Replies

  • kbarry's avatar
    kbarry
    Qrew Member
    2 days ago

    So, if I set equal to it pulls the records with that field name and hides the ones that don't but if I switch to not equal to it doesn't do the opposite like I believe it should.

      • kbarry's avatar
        kbarry
        Qrew Member
        2 days ago

        Thanks for the quick response. Im falling back on my Excel logic for "If/Thens" In QuickBase. 

        Can you help me learn some logic on this?

        Given what you said to change It would, in excel, error out the formula because it would be looking for the field 'Rejected' AND 'All items Received' and since both can't happen at the same time in a single field it would error out.

        I am confused on how it reads to me from QuickBase. 

        So, my understanding of Quickbase 'If then' is that even though it reads the same as excel QuickBase isn't lumping those 2 lines together and making sure both are true at the same time, it checks one line says true then moves to the next line and says true and that's how it passes the "all of these conditions are true" exception handling.

         

        Thanks again for the help!