I am trying to use a formula field on the Campaign Member object to pull from either a Lead or Contact. The Formula Text field works but the Formula Number field does not, and I am not sure why.

So On the Contact record I have a score of 65, but when I run a report with Campaign Members, the score shows 3.

Report Type: Campaign with Campaign Members.

IF( NOT(ISBLANK(Lead.Lead_Score__c)) , Lead.Lead_Score__c , 

IF( NOT(ISBLANK(Contact.Lead_Score__c)) , Contact.Lead_Score__c , 

  • What are the types of fields Lead_Score__c on contact and lead? – rahul gawale Jan 14 '19 at 16:55
  • They are both Number(10, 0) – nameishi Jan 14 '19 at 17:11
  • 2
    Try just comparing to null instead of checking ISBLANK. So use IF(Lead.Lead_Score__c != null, ..., ...). – Adrian Larson Jan 14 '19 at 17:27
  • I used the NOT(ISNULL()) that works. Thank you! – nameishi Jan 14 '19 at 17:31

This worked for me.

IF( NOT(ISNULL(Lead.Lead_Score__c)) , Lead.Lead_Score__c , 

IF( NOT(ISNULL(Contact.Lead_Score__c)) , Contact.Lead_Score__c , 

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.