Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have expression from Mr Ram :-
'S$ ' & 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')
I like to know how to make S$40141.77 display as S$40,141.77 ? i need a comma between 0 and 1 .
Paul
'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.00')
my QVW
try this
'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.00')
Hi,
In num(YourExpression,'###,##0.00')
Regards,
Hi,
you can remove internal num formatting.
Regards
Hi Paul,
Try this expression:
'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *
sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren)
,'###,##0.00')
HTH
KD
Hi Kedar
Your and Ram answer are correct , thank you
Paul