• Emily Chan
• NEWBIE
• 0 Points
• Member since 2015

• Chatter
Feed
• 0
• 1
• 0
Likes Given
• 2
Questions
• 0
Replies
This is how we caluclate call points: IF(
(
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case(  Infer_Rating2__c ,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1)
)
>= 0,
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case( Infer_Rating2__c,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1),
0)

What I want to do is; if (Account.infer_smart_signal_company_size__c) is "" or null, then look here (#_of_employees, "50-100", 0.5). how do I do this? how would I add it on to the current statement?

​Many thanks!
This is how we caluclate call points: IF(
(
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case(  Infer_Rating2__c ,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1)
)
>= 0,
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case( Infer_Rating2__c,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1),
0)

What I want to do is; if (Account.infer_smart_signal_company_size__c) is "" or null, then look here (#_of_employees, "50-100", 0.5). how do I do this? how would I add it on to the current statement?

Many thanks!
This is how we caluclate call points: IF(
(
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case(  Infer_Rating2__c ,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1)
)
>= 0,
Case( Seniority__c ,"VP",3,"Director",2,0)+
Case( Infer_Rating2__c,"A",1,"B",0.5,"D",-1,0)+
Case(Account.infer_smart_signal_company_size__c,"501-1000",0.5,"201-500",0,"51-200",-0.5,"",0,"1-10",-1,"11-50",-1,1),
0)

What I want to do is; if (Account.infer_smart_signal_company_size__c) is "" or null, then look here (#_of_employees, "50-100", 0.5). how do I do this? how would I add it on to the current statement?

​Many thanks!