Reply
Visitor
mdp84003
Posts: 2

Am I missing something? In Custom Reports, I want to use TWO values and an "or".

I cant figure out how to change the And to OR.  Any help for me?  Thanks in advance.
Trusted Contributor
Amber Neill
Posts: 169

Re: Am I missing something? In Custom Reports, I want to use TWO values and an "or".

On the Select Criteria page, click on the tiny "Advanced Options..." link at the very bottom of the Advanced Options section.

 

A new screen area will appear (as if by magic!).

Just below "Advanced Filter Conditions:" enter the following

"1 OR 2"

Where 1 is the first criteria and 2 is the second one.

 

I hope that makes sense!

 

You can use this to do more complex stuff too.  I have one report that looks kinda like this:

(((1 AND 2) OR (3 AND 4)) AND 5 AND 6)

 

Good Luck!
Amber

Visitor
mdp84003
Posts: 2

Re: Am I missing something? In Custom Reports, I want to use TWO values and an "or".

[ Edited ]

Maybe I don't pay for that link.  I don't see it.  Even after I enter the first advanced filter. Humm.

 

Yea, after further reading, my edition is LIMITED in this area of reporting. That sucks.  Now, I have to run two reports, same data, just more work and a bad taste in my mouth for SF.

Message Edited by mdp84003 on 08-13-2009 04:55 PM