Skip to main content
Topics#Data ManagementPergunta de meghna m
meghna m perguntou em #Data Management
21 de jan. de 2016, 06:47

Creating Custom formula field using IF ,OR NOT ,Contains at a time

I have a requirement where i need to create a formula field for given conditions.

 

when business segment is not equals to Government

 

1)If state is :ME:VT:NH:MA value will be USA EAST

 

2)when business segment is not equals to Government

 

If state is : AK:WA:OR:ID Value will be USA WEST

 

3)If Billing Country = Canada - CA

 

4)IF BS - Govt - Public sector

 

5)If Region is Latin America —Latin America.

 

The business segment is a picklist value and the Region is a formula field.

 

Any help very much appreciated.
1 resposta
  1. Head In Cloud (Head In Cloud)
    21 de jan. de 2016, 09:43
    Try this,

     

    IF(AND(NOT(ISPICKVAL( Business_Segment__c,"Government")),CONTAINS("ME:VT:NH:MA",MailingState)),"USA EAST",

     

    IF(AND(NOT(ISPICKVAL( Business_Segment__c,"Government")),CONTAINS("AK:WA:OR:ID",MailingState)),"USA WEST",

     

    IF(CONTAINS("Canada",MailingCountry),"CA",

     

    IF(ISPICKVAL( Business_Segment__c,"Government"),"Public Sector",

     

    IF(CONTAINS("Latin America",Region__c),"Latin America",""))))))

     

     
Escrever uma resposta...
0/9000