Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
could someone help me to add this condition:
CITIES_SUBSCRIPTIONS.city_id=42556
into this expression:
=aggr(
rangesum( above(Count({$<SUBSCRIPTIONS.is_subscribed = {'1'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>}SUBSCRIPTIONS.email)
-Count({$<SUBSCRIPTIONS.is_subscribed = {'0'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>}SUBSCRIPTIONS.email),0,rowno()))
, CALENDARIO_SUBSCRIPTIONS.AñoMes)
I tried several times but i couldn't.
Thanks a lot
Gerardo
well...fighting with this i found something.....i dont know if this is the best way but it help me....
=aggr(
rangesum( above(Count({$<SUBSCRIPTIONS.is_subscribed = {'1'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>} if(match(CITIES_SUBSCRIPTIONS.city_id,42556),SUBSCRIPTIONS.email))
-Count({$<SUBSCRIPTIONS.is_subscribed = {'0'}, CALENDARIO_SUBSCRIPTIONS.AñoMes=>} if(match(CITIES_SUBSCRIPTIONS.city_id,42556),SUBSCRIPTIONS.email)),0,rowno()))
, CALENDARIO_SUBSCRIPTIONS.AñoMes)