7 Replies Latest reply: Sep 14, 2016 5:39 AM by Gabriel Ferran RSS

    After insert ,if(US_Cust='MYR',1/3, 1) the expression not more working

    PAUL YEO

      Hi All

       

       

      i Have the below expression work fine :-

       

       

      'S$ ' &Num(

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days3)

      + sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days6) +

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * days9) +

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1))*above12)+

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) * curren)

      ,'###,##0.00')

       

       

      I try to adding one more currency for MYR :-

       

       

      'S$ ' &Num(

      sum(If( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1,if(US_Cust='MYR',1/3, 1))) * days3)+

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1,if(US_Cust='MYR',1/3, 1))) * days6) +

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1,if(US_Cust='MYR',1/3, 1))) * days9) +

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1,if(US_Cust='MYR',1/3, 1)))*above12)+

      sum(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1,if(US_Cust='MYR',1/3, 1))) * curren)

      ,'###,##0.00')

       

       

      above expression return null value , can some one advise me where i go wrong ?

       

       

      Paul