function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AJ76AJ76 

Custom Report advanced filters

Hi 

 

New to SFDC and just want to check what I am doing will work with the advanced filters. I want to run a report to make sure our salespeople have the correct accounts there are 4 basic criteria for the allocation but with one slight exception so I have 6 criteria on the report and have set up the following advanced filter would be grateful for any advice or just a sanity check on this:

 

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

 

So the desired results should be show in either 1,2 , 3 and 4 are all met or 1, 2, 3,  5 and 6 are met

 

Have I got that right? 

Best Answer chosen by Admin (Salesforce Developers) 
joker402joker402

You would want to close out the parentheses

 

you put:

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

should be:

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

 

but it seems fine. i put this into a query and got good data... 

All Answers

joker402joker402

You would want to close out the parentheses

 

you put:

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

should be:

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

 

but it seems fine. i put this into a query and got good data... 

This was selected as the best answer
AJ76AJ76

Thanks Joker

 

I did close out the parentheses in the org thanks for the sanity check! Don;t have any real support so this was my best method of having someone double check it.

 

I'd only get some smart comments if I proposed this and it went wrong.

 

Cheers

AJ