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
    Dec 9, 2016 at 19:49
  • @Oleksiy Yes, it's a formula field that adds Period 1 through Period 7. Dec 9, 2016 at 19:59
  • see my comment to @caleb.breckon answer
    – o-lexi
    Dec 9, 2016 at 20:04
  • @Oleksiy Error still occuring, please see edits to original post. 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.