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

    Replace Expression code with EditScript code

      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!