Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i need some help with set analysis syntax, it should be straight forward but i cant seem to get it to work.
i am trying to count an ID field but i only want to count the ID's where 2 other fields match.
count(distinct Contact_ID)
where campaignID=contactcampaignID
these 2 fields are in different tables
Can anyone help please?
Hi
This should do it:
=Count(Distinct If(campaignID=contactcampaignID, Contact_ID)
HTH
Jonathan
Hi
This should do it:
=Count(Distinct If(campaignID=contactcampaignID, Contact_ID)
HTH
Jonathan
Hi,
missing closing bracket.
=Count(Distinct If(campaignID=contactcampaignID, Contact_ID))
Regards
bracket missing from the end but it works thanks!
No syntax check in the post editor
Heheheeee
Got a bug