Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I got the below expression from Ram :-
'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(
sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)
,'###,##0.00'),'###,##0')
But when it sum up the 4 row of data , it display S$ 118,299 , which is wrong , How to make it display 159,141 ?
Paul
Hi,
Try this.
'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')
Regards,
Kaushik Solanki
my QVW
Hi,
Try this.
'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')
Regards,
Kaushik Solanki
Wow this is good, Thank a lot
Now i am able to sort from hi to lo.