0

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:

enter image description here

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)):

enter image description here

4
  • Is Pacing Total a formula field?
    – o-lexi
    Commented Dec 9, 2016 at 19:49
  • @Oleksiy Yes, it's a formula field that adds Period 1 through Period 7. Commented Dec 9, 2016 at 19:59
  • see my comment to @caleb.breckon answer
    – o-lexi
    Commented Dec 9, 2016 at 20:04
  • @Oleksiy Error still occuring, please see edits to original post. Commented Dec 9, 2016 at 21:02

1 Answer 1

1

As Pacing Total is a percentage field, the value for 100% would be 1:

NOT(
 OR( Pacing_Total__c = 0,
  Pacing_Total__c = 1
 )
)
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .