You need to sign in to do that
Don't have an account?
JJmemphis
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"
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"
Try this:
1 AND 2 AND 3 AND 6 AND NOT( 4 AND 5)
Let me know if it works
Thanks
All Answers
Try this:
1 AND 2 AND 3 AND 6 AND NOT( 4 AND 5)
Let me know if it works
Thanks
I actually wasn't aware of the function "Not" existing but it works perfectly.
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!
Thanks again.