Skip to main content
Topics#Reports & DashboardsFrank Woodward's Question
Frank Woodward asked in #Reports & Dashboards
Aug 21, 2020, 3:01 PM

Reporting filter: All Contacts with Activities not related to a Campaign

I'd like to add a cross filter to a Contacts & Organizations report, showing contacts that have no Activities that are related to a given campaign code. However, because a contact can have multiple activities, I'm having trouble determining the correct logic to use - I want to report only contacts for which every Activity (as opposed to any activity) is not Related To the campaign code. 

 

How do I add the "with every...not equal to" logic in a report filter?
2 answers
  1. Chloé Courtois (Doctolib)
    Aug 21, 2020, 3:14 PM

    Hi Frank

    In that case I would try the opposite : what you want is to look at all without a campaign

     

    So that would be something like "Activities without a campaign not equal to "" (null)"

     

    Does that make sense? :)

     

    Chloé
Write an answer...
0/9000