SF Community,
I am writing a validation rule where once an oppty hits a certian threshold in our ORG (25%) then it needs to have a dollar figure associated to it, however, I have run into the problem where:
A: You can enter the value 0
B: I need to make it where this is only applicable to a certain opportunity record type: IE: New Business Opportunity rather than Existing Business
Here's what I have built so far:
How would I allow it only to work for my new business record type and not allow 0.
Thanks!
-Drew
3 risposte
Try this:
AND(
Probability > 0.24,
OR(
New_Business_Amount__c = 0,
ISBLANK(New_Business_Amount__c)
),
RecordType.Name = "New Business"
)
