Hello,
I am editing a validation rule that I wrote that requries a custom currency field to be populated with more than $0.01 however I have the first exclusion coming from renewal side of the business and I'm trying to write a second line of syntex to include Sales_Type_c <> Channel Partner Client, which would allow $0.00 to be okay. Screenshots are below to detail what I'm working on:
8 个回答
Please use this -
AND(
Probability > 0.24,
OR(
New_Business_Amount__c = 0,
ISBLANK(New_Business_Amount__c)
),
RecordType.Name <> "Existing Business",
TEXT(Sales_Type__c) <> "Channel Partner Client"
)
