I have a section in Opportunities called Pacing and in this section there is a percentage field called Pacing Total. I need to create a Validation rule for this field so that if it doesn't equal 0 OR 100 an error pops up when a user is putting % in the Period fields:
Currently this is the formula I put in, but it's giving me a Syntax Error:
Pacing_Total__c = 0 || 100
Any help would be much appreciated. Thank you in advance.
EDIT - Error still occurring when using the following formula - NOT(OR(Pacing_Total__c = 0,Pacing_Total__c = 100)):
Pacing Total
a formula field?