Skip to main content

I have a Text formula field on the Account page that will categorize and account based on it's market and annual revenue. 

 

Here is the formula: 

IF(AND(TEXT( Market__c ) = "Commercial", AnnualRevenue < 50000000, AnnualRevenue > 0), "CorpSMB",

IF(AND( TEXT(Market__c)= "Commercial", AnnualRevenue >= 50000000), "CorpENT",

IF(AND( TEXT(Market__c)= "Commercial", ISBLANK(AnnualRevenue) ), "CorpUndefined",

IF( AND(CASE(TEXT(Market__c), "Association", 1, "Trade Association", 1, "Nonprofit", 1,"Education",1,"Government", 1,2)=1,AnnualRevenue < 5000000, AnnualRevenue > 0) , "AssocSMB",

IF( AND( CASE(TEXT(Market__c), "Association", 1, "Trade Association", 1, "Nonprofit", 1,"Education",1,"Government", 1,2)=1,AnnualRevenue >= 5000000) , "AssocENT",

IF( AND( CASE(TEXT(Market__c), "Association", 1, "Trade Association", 1, "Nonprofit", 1,"Education",1,"Government", 1,2)=1, ISBLANK( AnnualRevenue ) ) , "AssocUndefined",

IF(AND( ISBLANK( TEXT(Market__c) ) , OR(AnnualRevenue >= 0, ISBLANK(AnnualRevenue) ) ), "Undefined", "Undefined") ) ) ) ) ) )

 

 

The issue is that some of the verticals are not displaying correctly. 

 

For example I have some cases where the market is commercial and annual revenue is $2M but the vertical is being displayed as undefined. 

Hoping you guys can help. 

 

Lionel
10 answers
  1. Aug 15, 2019, 3:41 PM
    Does it work for othe rpicklist values?  Is it Only Commercial the issue is with?
0/9000