I have a validation rule: When the stage name is changed to "4. Proposal" then the max discount should be > 5 and Special_Pricing_Approved should be = false.
My validation rule:
IF((ISPICKVAL(StageName , "4. Proposal")), And(Max_Discount__c < 5, Special_Pricing_Approved__c == true),null)
Is this the correct rule as per my requirement? This validation gets fired when max discount > 5 or < 5 same with pecial_Pricing_Approved get fire if it is true or false. What is wrong with my validation rule?
Error from debug:
VALIDATION_RULE|Opportunity_to_Proposal |VALIDATION_FORMULA|AND( ISPICKVAL(StageName , "4. Proposal") , OR(Max_Discount__c <= 5 , Special_Pricing_Approved__c = true ) )|Max_Discount__c=21.05 , StageName=4. Proposal , Special_Pricing_Approved__c=0 VALIDATION_FAIL