You need to sign in to do that
Don't have an account?
Lakshmi S
Formula issue
Hi Team,
How can we simplify below formula.
OR(AND(OR(ISPICKVAL(Region__c,"West"),ISPICKVAL(Region__c,"North"),ISPICKVAL(Region__c,"South"),ISPICKVAL(Region__c,"East"),ISPICKVAL(Region__c,"Northeast"),ISPICKVAL(Region__c,"Latin America")),Annualized_EBITDA__c >=1500000),AND(OR(ISPICKVAL(Region__c,"A&T AMS"),ISPICKVAL(Region__c,"A&T APAC"),ISPICKVAL(Region__c,"A&T EMEA"),ISPICKVAL(Region__c,"APAC"),ISPICKVAL(Region__c,"Competitors"),ISPICKVAL(Region__c,"DCS"),ISPICKVAL(Region__c,"EMEA"),ISPICKVAL(Region__c,"Govt & PS"),ISPICKVAL(Region__c,"Healthcare"),ISPICKVAL(Region__c,"I&M"),ISPICKVAL(Region__c,"Life Sciences"),ISPICKVAL(Region__c,"LFM")),Annualized_EBITDA__c >=1000000),AND(OR(ISPICKVAL(StageName,"Win (Contract Signed)"),ISPICKVAL(StageName,"Lost Accounts"),ISPICKVAL(StageName,"Lost Pursuits"),ISPICKVAL(StageName,"On Hold"),ISPICKVAL(StageName,"Dead"),ISPICKVAL(StageName,"Declined")),!ISPICKVAL(Win_Loss_Year__c ,"2018"),Annualized_EBITDA__c >=1000000))
Regards
Lakshmi
How can we simplify below formula.
OR(AND(OR(ISPICKVAL(Region__c,"West"),ISPICKVAL(Region__c,"North"),ISPICKVAL(Region__c,"South"),ISPICKVAL(Region__c,"East"),ISPICKVAL(Region__c,"Northeast"),ISPICKVAL(Region__c,"Latin America")),Annualized_EBITDA__c >=1500000),AND(OR(ISPICKVAL(Region__c,"A&T AMS"),ISPICKVAL(Region__c,"A&T APAC"),ISPICKVAL(Region__c,"A&T EMEA"),ISPICKVAL(Region__c,"APAC"),ISPICKVAL(Region__c,"Competitors"),ISPICKVAL(Region__c,"DCS"),ISPICKVAL(Region__c,"EMEA"),ISPICKVAL(Region__c,"Govt & PS"),ISPICKVAL(Region__c,"Healthcare"),ISPICKVAL(Region__c,"I&M"),ISPICKVAL(Region__c,"Life Sciences"),ISPICKVAL(Region__c,"LFM")),Annualized_EBITDA__c >=1000000),AND(OR(ISPICKVAL(StageName,"Win (Contract Signed)"),ISPICKVAL(StageName,"Lost Accounts"),ISPICKVAL(StageName,"Lost Pursuits"),ISPICKVAL(StageName,"On Hold"),ISPICKVAL(StageName,"Dead"),ISPICKVAL(StageName,"Declined")),!ISPICKVAL(Win_Loss_Year__c ,"2018"),Annualized_EBITDA__c >=1000000))
Regards
Lakshmi
You cannot use a regex in a formula but there is also contains.
Contains = Compares two arguments of text and returns TRUE if the first argument contains the second argument. If not, returns FALSE.
CONTAINS("West|North|South|East|Northeast|Latin America", TEXT(Region__c))
is equivalent to:
OR(
ISPICKVAL(Region__c,"West"),
ISPICKVAL(Region__c,"North"),
ISPICKVAL(Region__c,"South"),
ISPICKVAL(Region__c,"East"),
ISPICKVAL(Region__c,"Northeast"),
ISPICKVAL(Region__c,"Latin America")
),
==================================
OR(AND(
OR(
ISPICKVAL(Region__c,"West"),
ISPICKVAL(Region__c,"North"),
ISPICKVAL(Region__c,"South"),
ISPICKVAL(Region__c,"East"),
ISPICKVAL(Region__c,"Northeast"),
ISPICKVAL(Region__c,"Latin America")
),
Annualized_EBITDA__c >=1500000),
AND(
OR(
ISPICKVAL(Region__c,"A&T AMS"),
ISPICKVAL(Region__c,"A&T APAC"),
ISPICKVAL(Region__c,"A&T EMEA"),
ISPICKVAL(Region__c,"APAC"),
ISPICKVAL(Region__c,"Competitors"),
ISPICKVAL(Region__c,"DCS"),
ISPICKVAL(Region__c,"EMEA"),
ISPICKVAL(Region__c,"Govt & PS"),
ISPICKVAL(Region__c,"Healthcare"),
ISPICKVAL(Region__c,"I&M"),
ISPICKVAL(Region__c,"Life Sciences"),
ISPICKVAL(Region__c,"LFM")
),
Annualized_EBITDA__c >=1000000),
AND(
OR(
ISPICKVAL(StageName,"Win (Contract Signed)"),
ISPICKVAL(StageName,"Lost Accounts"),
ISPICKVAL(StageName,"Lost Pursuits"),
ISPICKVAL(StageName,"On Hold"),
ISPICKVAL(StageName,"Dead"),
ISPICKVAL(StageName,"Declined")
),
!ISPICKVAL(Win_Loss_Year__c ,"2018"),
Annualized_EBITDA__c >=1000000))
====================================
Thnaks for your suggestion.