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
Does it work for othe rpicklist values? Is it Only Commercial the issue is with?