issue with count, set analysis, modifier

gerrycastellino — Wed, 20 Jul 2016 20:10:59 GMT

This statement does not seem to work with the modifier:

I'm looking for the difference between 2 states with the modifier (default and Exclusion)

Count( {$-Exclusion} DISTINCT {< account_uuid = {"*"}>} contact_uuid)

If I remove the modifier, I'm getting a correct total.

Count( {$-Exclusion} DISTINCT contact_uuid)

Re: issue with count, set analysis, modifier

sunny_talwar — Wed, 20 Jul 2016 20:15:40 GMT

Do you want this:

Count({$-Exclusion <account_uuid = {"*"}>} DISTINCT contact_uuid)

Count({$<account_uuid = {"*"}> - Exclusion <account_uuid = {"*"}>} DISTINCT contact_uuid)