You need to sign in to do that
Don't have an account?
Kbhaskar
validation rule amount
hi have an error where need to save amount with respect to record types
Error: Syntax error. Found ')'
AND(
OR(
Amount<10000,
Amount<>10000,
OR(
$RecordType.Name="Small Opportunities",
$RecordType.Name="Big Opportunities",
)))
Error: Syntax error. Found ')'
AND(
OR(
Amount<10000,
Amount<>10000,
OR(
$RecordType.Name="Small Opportunities",
$RecordType.Name="Big Opportunities",
)))
Please change syntax as mentione below :
AND(
OR(
Amount<10000,
Amount<>10000,
OR(
$RecordType.Name="Small Opportunities",
$RecordType.Name="Big Opportunities"
)))
Something is wrong with your logic,
1) OR(
Amount<10000,
Amount<>10000,
since <10000 is already covered in <>10000, you don't need both, or change your criteria
2) Why have an AND when there're just one OR in there, so look at you logic and see if you meant to have many ORs
Base on what you wrote, I believe you are trying to do this:
As a common practice, if your question is answered, please choose 1 best answer.
But you can give every answer a thumb up if that answer is helpful to you.
Thanks
I came close to my solution it was the problem with logic. thanks a lot William Tran & Abhishek Bansal !
Bhaskar, glad you figure it out, if your question is answered, please choose a best answer.
Thanks