4 Replies Latest reply: Jul 28, 2016 5:15 AM by PAUL YEO RSS

    How to make my Total Amount currency convert from RP 7,353,062.00 * 0.0001 = SGD $ 735 Now only display SGD 479.14

    PAUL YEO

      Hi All

       

       

      I have expression from Kaushik it 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 need to add one more currency RP to above expression :-

       

       

      'S$ ' &Num(

      sum(

      If( US_Cust='USD', 1.3,

      If( US_Cust='RP', 0.0001,

      if( US_Cust='EU',1.5, 1)))* days3)

       

      + sum(

      If ( US_Cust='USD', 1.3,

      If ( US_Cust='RP', 0.00001,

      if ( US_Cust='EU',1.5, 1))) * days6)

       

       

      +sum(

      If ( US_Cust='USD', 1.3,

      If ( US_Cust='RP', 0.00001,

      if ( US_Cust='EU',1.5, 1))) * days9)

       

       

      +sum(

      If ( US_Cust='USD', 1.3,

      If ( US_Cust='RP', 0.00001,

      if ( US_Cust='EU',1.5, 1)))*above12)

       

       

      +sum(

      If ( US_Cust='USD', 1.3,

      If ( US_Cust='RP', 0.00001,

      if ( US_Cust='EU',1.5, 1))) * curren)

      ,'###,##0.00')

       

       

      But it display wrong amount SGD 479.14 , it should display some where SGD$ 700.

       

       

      Paul