Multiple criteria in an expression

[zototo]

Hi everyone, 

Hope to get some help.  What I need in the result is to have the COUNT of SHOP_NAME where both Game Suppliers "GF" and "PS" Count Game >0. 

I've tried different expressions but none of them is giving me the right result. Here's the latest one, but still it gives me the sum of shops where is only GF and only PS:

count({ $< COUNT_GAMES = {"=COUNT_GAMES > '0'"}, TermType = {'TB'}, [Game Supplier] = {'GF'}>+ <COUNT_GAMES = {"=COUNT_GAMES > '0'"}, TermType = {'TB'}, [Game Supplier] = {'PS'}>} distinct SHOP_NAME)

Would be great to have any ideas here.

Thank you!

[MayilVahanan]

Hi

Try like below

Count({ $< SHOP_NAME= {"=Sum(COUNT_GAMES )> 0"}, TermType = {'TB'}, [Game Supplier] = {'GF'}>+ <SHOP_NAME = {"=Sum(COUNT_GAMES )> 0"}, TermType = {'TB'}, [Game Supplier] = {'PS'}>} distinct SHOP_NAME)