17 Replies Latest reply: May 20, 2016 1:47 PM by Settu Periyasamy RSS

    Replace Expression code with EditScript code

    Maneck Mehta

      I am using following in the expression which works just fine(shown in red). For some other reasons(cant elaborate here) i want to replace below expression code(in red) with EditScript code(in green)

       

      Expression Code :-

      =sum({<Market={'Italy'}>}[Unique Leads 1 Month])/sum({<Market={'Italy'}>}[Active Contacts])

       

       

      Edit Script Code:-

      sum(if(COD_MARKET='Italy',[Unique Leads 1 Month]))/sum(if(COD_MARKET='Italy',[Active Contacts])) as LeadsByActiveContacts 



      I tried to do the following to replace the expression but it doesn't work!


      =LeadsByActiveContacts