if condition in set analysis. ?

[suvechha_b]

Hi All ,

How can I write this if condition in set analysis.

=If(Count(DISTINCT if(dealstate_id=8 or dealstate_id =9 ,customerIdNumber))>0,'Yes','No')

[tresesco]

If(Count( Distinct {<dealstate_id={8,9}>} customerIdNumber) >0,'Yes','No')

[nishanthi_8]

if(count(distinct {<dealstate_id={8,9}>} customerIdNumber)>0,'Y','N')

[ogautier62]

Hi,

something like that :

if(count ({<dealstate_id = {8,9} >} distinct customerIdnumber ) >0,'yes','no')

it depends on your context : chart or textbox

may be add all in count if necessary

in a chart this will be calculated on your dimension

aggr if you want another dimension

regards