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
