Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Below expression with help of few people help now working fine :-
'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.0001,
if ( US_Cust='EU',1.5, 1))) * days6)
+sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days9)
+sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1)))*above12)
+sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * curren)
,'###,##0.00')
I need to exclude SEGMENT = Related Coy from the table , i try the expression below :-
'S$ ' &Num(
sum(
If( US_Cust='USD', 1.3,
If( US_Cust='RP', 0.0001,
if( US_Cust='EU',1.5, 1))){<SEGMENT -= {'Related Coy'}>}*days3)
+ sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) {<SEGMENT -= {'Related Coy'}>}*days6)
+sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) {<SEGMENT -= {'Related Coy'}>}*days9)
+sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))){<SEGMENT -= {'Related Coy'}>}*above12)
+sum(
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) {<SEGMENT -= {'Related Coy'}>}*curren)
,'###,##0.00')
it does not work. Hope some one can advise me where i go wrong ?
Paul
Try here:
'S$ ' &Num(
sum({<SEGMENT -= {'Related Coy'}>}
If( US_Cust='USD', 1.3,
If( US_Cust='RP', 0.0001,
if( US_Cust='EU',1.5, 1)))* days3)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days6)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days9)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1)))*above12)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * curren)
,'###,##0.00')
my QVW
Try here:
'S$ ' &Num(
sum({<SEGMENT -= {'Related Coy'}>}
If( US_Cust='USD', 1.3,
If( US_Cust='RP', 0.0001,
if( US_Cust='EU',1.5, 1)))* days3)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days6)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days9)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1)))*above12)
+ sum({<SEGMENT -= {'Related Coy'}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * curren)
,'###,##0.00')
'S$ ' &Num(
sum({<SEGMENT -= {"Related Coy"}>}
If( US_Cust='USD', 1.3,
If( US_Cust='RP', 0.0001,
if( US_Cust='EU',1.5, 1)))* days3)
+ sum({<SEGMENT -= {"Related Coy"}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days6)
+sum({<SEGMENT -= {"Related Coy"}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * days9)
+sum({<SEGMENT -= {"Related Coy"}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1)))*above12)
+sum({<SEGMENT -= {"Related Coy"}>}
If ( US_Cust='USD', 1.3,
If ( US_Cust='RP', 0.0001,
if ( US_Cust='EU',1.5, 1))) * curren)
,'###,##0.00')