Validation Rule not working - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Kumar VikashKumar Vikash 

Validation Rule not working

I have a very simple validation rule that has been giving me bugging me for a while. Can anyone please help me in finding what am I doing wrong.

Here's the error condition formula -
AND (

RecordType.Name = "Specialty Risk" ,
Submit_for_Approval__c = True ,
OR (

Total_Average_Trip_Cost_Breakdown__c <> 1.00 ),
ISBLANK( Average_Trip_Cost__c )

)

here's the log

User-added image
Best Answer chosen by Kumar Vikash
Jayson MoralesJayson Morales
Hi Kumar,

You might want to try this:
 
AND (
RecordType.Name = "Specialty Risk" ,
Submit_for_Approval__c = True ,
OR (
Total_Average_Trip_Cost_Breakdown__c <> 1.00 ,
ISBLANK( Average_Trip_Cost__c )
)
)

Hope that helps.

Regards,
Jayson

All Answers

Jayson MoralesJayson Morales
Hi Kumar,

You might want to try this:
 
AND (
RecordType.Name = "Specialty Risk" ,
Submit_for_Approval__c = True ,
OR (
Total_Average_Trip_Cost_Breakdown__c <> 1.00 ,
ISBLANK( Average_Trip_Cost__c )
)
)

Hope that helps.

Regards,
Jayson
This was selected as the best answer
Kumar VikashKumar Vikash
There's a closing parenthesis. How did I spend half a day on this and still miss this!

Thank you. This helps.