1 Reply Latest reply: Sep 14, 2016 7:48 AM by PAUL YEO RSS

    How to insert If SOURCE = TDSS , US_Cust=USD use 1.3 rate , If SOURCE = TDSKL , US_Cust=USD use 4.3 rate to my expression ?

    PAUL YEO

      Hi All

       

       

      My below exlow expression work fine :-

       

       

      'S$ ' &Num(

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

      ,'###,##0.00')

       

       

      I need to add below condition on to the above expression :-

       

       

      If SOURCE = TDSS , US_Cust=USD use 1.3 rate

      If SOURCE = TDSKL , US_Cust=USD use 4.3 rate

       

       

      Can some one advise me how to insert the above condition ?

       

       

      When user click on SOURCE = TDSKL , The amount should display 233,613.74

      When user click on SOURCE = TDSS , The amount should display 18,662

       

       

      Paul