How to Count 3 conditional counts

[#1]

I got a expression like this

COUNT(IF(categori='x' OR categori='y',item)) and want to add an extra condition.

Somthing like this

COUNT(IF(YEAR='2011' AND categori='x' OR categori='y',item))
but this expression does´nt work right - I do not get the right result

[#2]

COUNT(IF(YEAR='2011' AND categori='x' AND categori='y',item))

[#3]

hi ,

if category have one value ( X or Y)

COUNT(IF(YEAR='2011' AND (categori='x' OR categori='y'),item))

[#4]

Hello Did you try this Set Analysis:

COUNT({$<YEAR = '2011', Categori = {'x', 'y'}>} item)

Can you please try and let me know.

Thanks

[#5 · Accepted solution]

Hi,

Try Count ( if ( year = '2011' , if ( catagory = 'X' or catagory = 'Y' , item ) ) )

Regards,

Shubhu

[#6]

MUCHO

the expression gives med a 0 - and that is wrong

[#7]

shubhu - Your expression works for me