1 Reply Latest reply: Mar 19, 2012 3:57 PM by gerardo.pauza RSS

    adding condition in expression

      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

        • adding condition in expression

          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)