"Has any of" vs "Has all of"

Options

When filtering a report, what is the difference between the option of "has any of" vs "Has all of"?

Tags:

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    Options

    Has any of looks to see if any of the options are there before filtering the rest. Where has all of checks that the field Has every option before showing it.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • MarkCep
    MarkCep ✭✭✭✭
    Options

    @Mark.poole thank you for the info, but I am trying to put my brain around what you are saying and it is not making sense. Here's my deal, I have a report with 5 filters , one of the filters is for a contact column (Project Manager) there are 8 PM's available, I am filtering for only 1, do I use any or all?

    I will be using the "current user" as well for another version of the report- do I use ANY or ALL?

    I feel like an idiot not grasping this.

    I also could not find any documentation regarding this question in SS help.

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    Options

    just do a filter for is one of and pick the name you want

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.