Skip to main content
Topics#Data ManagementPregunta de Roman Draut
Roman Draut (Macys) ha preguntado en #Data Management
19 mar 2018, 21:46

I am trying to write a formula with multiple OR statements so that a text field displays either "Y" or "N". I can't get the syntax correct. Any help is greatly appreciated.

Here's the formula:

 

IF(

 

OR(

 

MID(MACYS_Account_Code__c,3,4) = '3541'),

 

(MID(MACYS_Account_Code__c,3,4) = '3540'),

 

(MID(MACYS_JobTitle__c,1,6) = 'ES1021'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EL0011'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EL0015'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EL0028'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EL0051'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EO0014'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EO0116'),

 

(MID(MACYS_JobTitle__c,1,6) = 'EO0136'),

 

(MID(MACYS_JobTitle__c,1,6) = 'ER0007'),

 

(MID(MACYS_JobTitle__c,1,6) = 'ES0022'),

 

(MID(MACYS_JobTitle__c,1,6) = 'ES0032'),"Y","N")
6 respuestas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    20 mar 2018, 2:20

    If you're just evaluating the same field over and over again you could use a CASE funtion like this

    CASE( MID( Text_1__c ,3,4), 
    '3541',"Y",
    '3540',"Y",
    CASE( MID( Text_1__c ,1,6),
    'ES1021',"Y",
    'EL0011',"Y",
    'EL0015',"Y",
    'EL0028',"Y",
    'EL0051',"Y",
    'EO0014',"Y",
    'EO0116',"Y",
    'EO0136',"Y",
    'ER0007',"Y",
    'ES0022',"Y",
    'ES0032',"Y",
    "N"))

     

     
Escribir una respuesta...
0/9000