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 ...
reports
  • MarkShnier__You's avatar
    MarkShnier__You
    2 days ago

    np, just change the "any" to "all"

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.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 days ago

np, just change the "any" to "all"

  • 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!