New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.

scan return incorrect results

I created a scan in which I do not want the following 3 groups to be included, but the result of the scan only returns data for those 3 groups. What am I doing wrong?

this is the function I typed in:

and [ [group != Biotechnology] or [group != Pharmaceuticals] or [group != FinancialSector] ]

Thanks for your help!

Comments

  • markdmarkd ✭✭✭


    Change "or" to "and".

    Biotech is not Pharmaceuticals, so it fits one of your "or" conditions (not Pharmaceuticals), so it's a hit.

    Same for the other two.

    Biotech is Biotech, so it violates one of your "and" conditions, so even if any other number of conditions is true, it won't be a hit because it violates that one "and" condition.

    So, ALL "and" conditions must be true to get a hit.

    But if you have a series of "or" conditions, only ONE has to be true to get a hit (provided all the "and" conditions in the same scan are also true).


    You can leave the syntax as is, or you can rewrite it:

    // previous things
    ...

    // exclude all these groups
    and [group != Biotechnology]
    and [group != Pharmaceuticals]
    and [group != FinancialSector]

    // next things

    ...
Sign In or Register to comment.