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 , 3))