5 Replies Latest reply: Nov 24, 2015 2:09 AM by jagan mohan rao appala RSS

    Adding two different values in set analysis

    Kumar Pramod

      Hi all,

       

      I have two set expressions which get two different counts of different campaigns. Now, i need to add the two counts.

      Expressions:


      1)  IF(match(Metrics, 'List Size'),sum({$<email_type_id = {44}, campaign_name_id = {"$(=max(campaign_name_id)-11)"}>}delivered))

       

      2)  IF(match(Metrics, 'List Size'),sum({$<email_type_id = {44}, campaign_name_id = {"$(=max(campaign_name_id)-9)"}>}delivered))

       

      I need to add the counts of two different Campaign_name_id's.

       

      I used like below but not working

      IF(match(Metrics, 'List Size'),sum({$<email_type_id = {44}, campaign_name_id = {"$(=max(campaign_name_id)-11)","$(=max(campaign_name_id)-9)"}>}delivered),

       

       

      Thanks,

      Kuamr