Set analysis problem

[#1]

Hi,  I'm struggling with a bit of set analysis. From the sample data below I'm trying to do a count of calls into response groups where they are missed. So id 1 went to 3 different users but was answered by one person so my expression would return 0. Id 2 went to 4 different users and was not answered by anyone and therefore would return 1.

ID      call_response

1       Answered

1       Missed

1       Missed

2       Missed

2       Missed

2       Missed

2       Missed

Help please!

Thanks

Neil

[MayilVahanan]

Hi,

     Try this,

          =If(Aggr(Count({<call_response = {'Answered'}>}call_response),ID) > 0 ,0 ,1)

     Hope it helps