topic Re: Count if Distinct with a Set Modifier in App Development

Count if Distinct with a Set Modifier

joeybird — Thu, 08 Oct 2015 14:16:56 GMT

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 — Thu, 08 Oct 2015 14:28:12 GMT

Hi Joana, can you try this?:

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

joeybird — Thu, 08 Oct 2015 15:20:15 GMT

Hiya

It don't work properly sorry needs the if

please help

sunny_talwar — Thu, 08 Oct 2015 15:20:57 GMT

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

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

sunny_talwar — Thu, 08 Oct 2015 15:22:00 GMT

or may be this:

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