4 Replies Latest reply: Jan 18, 2018 11:27 PM by P M RSS

    why my load script last line not work ?

    Yeo Poh sai

      Hi All


      I have a field on sales stage the label very long , i like to shorten it :-


      Replace([Opportunities Sales Stage],' ','_') as [Sales Stage], 


      Closed_Lost

      Closed_Won

      Commitment_to_Buy

      Initial_Communication

      Needs_Assessment

      Negotiation

      Pending

      Prospecting

      Sales_Fulfillment


      So i create a new script :-


           if([Opportunities Sales Stage]='Closed Lost', '8C_LOST',

      if([Opportunities Sales Stage]='Closed Won', '9C_WON',

      if([Opportunities Sales Stage]='Commitment to Buy', '5_COM2BUY',

      if([Opportunities Sales Stage]='Initial Communication', '1INT_COM',

      if([Opportunities Sales Stage]='Needs Assessment', '2NEED_AS',

      if([Opportunities Sales Stage]='Negotiation', '4NEGO',

      if([Opportunities Sales Stage]='Pending', '6PENDING',

      if([Opportunities Sales Stage]='Prospecting', '3PROPOSE',

      if([Opportunities Sales Stage]='Sales_Fulfillment', '7SALE_FULL',

      ))))))))) as [Sales Stage],

       

      My above load script work fine for all label , except below linie :-


      if([Opportunities Sales Stage]='Sales_Fulfillment', '7SALE_FULL',


      it just display record the Sales_Fullfillment into 7SALES_FULL


      Paul