I am customizing our Campaign page and adding a field called "Total Participants". I want to only count Campaign Members whose status is not equal to "No Show", "Not Attending". This is simple to do in a report, but I'm not sure how to incorporate it into a formula.
I found this Salesforce forum post, but from my understanding it would require creating a new report for each Campaign.
The best I can come up with is:
// LEN(GETRECORDIDS()) gets total number of records from a certain object // `Self` is wrong but I'm not sure how to reference the current object's sub-objects LEN(GETRECORDIDS(( Self.CampaignMember.Status != "Not Attending") && (Self.CampaignMember.Status != "No Show") ))
I'm betting this is far off base, but I'm not sure what direction to take this while keeping to the confines of a formula field.