4

I am building a report and need to build the following condition in the What filter group:

 

    [Field 1] is not checked

and

    [Field 2] is checked

or

    [Field 3] is checked

 

 

In other words, it will first look for rows where [Field 1] is not checked and then further filter that dataset to only show rows where [Field 2] or [Field 3] is checked. However, it looks like I cannot mix AND and OR functions within the same group.

 

Any thoughts on how to accomplish this? Moreover, can this be added to the feature request list?

 

Comments

Ramsay,

 

One way to do something like this is to do the logic in a separate column using IF() functions and then use that column in the report builder to select rows that meet the condition. 

Ramsay,

 

I'm pretty sure Jim's solution is the best (and only viable one

 

Make sure you get your paranthesis correct or use the AND/OR functions

 

=IF(AND(NOT([Field 1]23),OR([Field 2]23,[Field 3]23)),1,0)

 

shoudl be faster than a longer set of IF statements.

 

Craig

I would like to see the original post added to the feature request list as I have a similar requirement. Not only to be able to have a combination of "and" and "or" in the report request but to be able to group them appropriately (ie equivalent of being able to parnethesise as needed). I don't want to add extraneous columns into my original sheet as it is used and viewed by many.

I just realized that this is an issue too. Should not have to do an IF formula to use "and" and "or" versus "and" and "and" or "or" and "or."