+ Start a Discussion
JJmemphisJJmemphis 

Validation Rules In Report

I'm trying to get the below work but it's not populating the way I want it to.
1. Needs to be true
2. Needs to be true
3. Needs to be true
6  Needs to be true
and if 4 and 5 are true it needs to not appear on the report.

Any ideas On what I need to change as that is the only part that isn't working properly.

(3 OR 2 OR (4 AND 5))Filter Logic: (1 AND (3 OR 2 OR (4 AND 5)) AND 6)
1. Responsible Company equals "Enterprise Insurance Group"
2. Record Type not equal to "PEO"
3. Status equals "Active"
4. Record Type Equal to "Workers Compensation"
5. Premium greater than ""15,000""
6. Special Account not equal to "True"
Best Answer chosen by JJmemphis
Narender Singh(Nads)Narender Singh(Nads)
Hi JJ,
Try this:
1 AND 2 AND 3 AND 6 AND NOT( 4 AND 5)

Let me know if it works
Thanks

All Answers

Narender Singh(Nads)Narender Singh(Nads)
Hi JJ,
Try this:
1 AND 2 AND 3 AND 6 AND NOT( 4 AND 5)

Let me know if it works
Thanks
This was selected as the best answer
JJmemphisJJmemphis
Thank you!
I actually wasn't aware of the function "Not" existing but it works perfectly.
Narender Singh(Nads)Narender Singh(Nads)
You're welcome!
If you don't mind please mark a best answer for this post so that others with similar problem can benefit from this post.

Thanks!
JJmemphisJJmemphis
Done!
Thanks again.
Narender Singh(Nads)Narender Singh(Nads)
Happy to help. :D