Skip to main content
Topics#Data ManagementGurpreet Cheema's Question
Gurpreet Cheema (Wipro) asked in #Data Management
Nov 17, 2020, 4:29 PM

Either/or validation rule

Hi I am trying to create a validation rule to throw an error when a valid Pricebook is not selected so:

 

 

 

If Entity selected is A, Price book can only be PB1 or PB2

 

If Entity selected is B, Price book can only be PB2 or PB3

 

If Entity selected is C, Price book can only be PB2 or PB4

 

If Entity selected is D, Price book can only be PB5 or PB6

 

I have so far created this but this doesn't work as expected. Can you help please?

 

OR(AND( EntityName__c <> 'A', PriceBook__c <> 'PB1', PriceBook__c <> 'PB2')

 

,

 

AND( EntityName__c <> 'A', PriceBook__c <> 'PB3', PriceBook__c <> 'PB2')

 

,

 

AND(EntityName__c <> 'A', PriceBook__c <> 'PB4', PriceBook__c <> 'PB2')

 

,

 

AND(EntityName__c <> 'A', PriceBook__c <> 'PB5', PriceBook__c <> 'PB6'))

 

Can someone help me please?
9 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Nov 20, 2020, 4:48 PM
    Hi,

     

    Ok, then change the "=1" to "=0" in my formula. When there is only one SBQQ__PriceBook__r.Name, change the "=" to "<>"
Write an answer...
0/9000