Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Joana, can you try this?:
Count(DISTINCT {<[Country] ={"America"}, Target={"<35"}>} Check_Number)
Hiya
It don't work properly sorry needs the if
please help
I think for excluding he would need a negative sign, right?
Count(DISTINCT {<[Country] -= {'America'}, Target={"<35"}>} Check_Number)
or may be this:
Count(DISTINCT {<Country = e({<Country = {'America'}>}), Target={"<35"}>} Check_Number)