Count if Distinct with a Set Modifier

[joeybird]

Hiya

have a expression like this

count ( distinct  if([Target]<'35', Check_Number))

but  I want to add a set Modifier to it

I want to exclude customers from e.g  a country America

how would I please add this {$<[Country] ={"America"} >}

I try but my bars still shows for America as 0, but I want it to not appear

Kind Regards

[rubenmarin]

Hi Joana, can you try this?:

Count(DISTINCT {<[Country] ={"America"}, Target={"<35"}>} Check_Number)

[joeybird]

Hiya

It don't work properly sorry needs the if

please help

[sunny_talwar]

I think for excluding he would need a negative sign, right?

Count(DISTINCT {<[Country] -= {'America'}, Target={"<35"}>} Check_Number)

[sunny_talwar]

or may be this:

Count(DISTINCT {<Country = e({<Country = {'America'}>}), Target={"<35"}>} Check_Number)