Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
Check your expression. It seems the value of RP is not same across.
In Day3 you are using 0.0001 where as for other you are using 0.00001.
Regards,
Kaushik Solanki
my qvw
The expression seems correct, probably the number 0.00001 is too llittle to be multiplied so it is rounded to zero.
try to substitute the number 0.00001 with another number (E.G. 1.1) and verify if expression works. if it does then use Round(nnn, nnnnn) before the Sum (function)
HI,
Check your expression. It seems the value of RP is not same across.
In Day3 you are using 0.0001 where as for other you are using 0.00001.
Regards,
Kaushik Solanki
Hi Kau
You are right , you spot the mistake i make , all should be 0.0001 and not 0.00001 , like aless mentioned .