3 Replies Latest reply: Jul 28, 2016 5:33 AM by PAUL YEO RSS

    Where to insert {<SEGMENT -= {'Related Coy'}>} into my SET expression ?

    PAUL YEO

      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