I would like to track total sales that are related to people in a campaign only if the sales is after when they were added to the campaign.
Here's what I have but I keep getting an error-
IF( ISBLANK( SUM( IF( FirstSaleDate__c >= Contact_ID__c.CreatedDate, TotalSales__c, 0 ) ) ), 0, SUM( IF( FirstSaleDate__c >= Contact_ID__c.CreatedDate, FirstSaleDate__c, 0 ) ) )
Here's the error I keep getting-"Error: Field Contact_ID__c does not exist. Check spelling."
This field does exist in my contacts object. Please advise.
Contact_ID__r. When fetching data on related records, you use
__c(or drop the "Id" if it's a standard relationship field, e.g. On Account,