I need to create a custom report for stale contacts that shows all contacts associated with the parent companies of Pennsylvania or Philadelphia. But when I run the report it shows every single contact that is associated with Philadelphia.
My filters are listed below. I get the correct records for Pennsylvania but not for the Philadelphia parent company.
Filter Logic:(((((1 AND (2 OR 3))) AND 4) or 5)) AND 6
EditRemove
1. Lead Status equals "New,Active,Prospect"
EditRemove
2. Last Activity less than "14 DAYS AGO"
EditRemove
3. Last Activity equals ""
EditRemove
4. Parent Company contains "Pennsylvania"
EditRemove
5. Parent Company contains "Philadelphia"
EditRemove
6. Contact Type equals "Primary Mentor"
EditRemove
4 respuestas
Brooks,
It appears you would just need this:
1 AND (2 OR 3) AND (4 OR 5) AND 6
