7 Replies Latest reply: Jul 28, 2016 6:54 AM by saima siddiqui RSS

    My Table Top 3 row value are null How to suppress ?

    PAUL YEO

      Hi All

       

      I have the expression with the help from sunny it working fine :-

       

      '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')

       

       

      Now the Top 3 row Segment = Related Coy , the Amount is zero.

       

       

      Now my question is how to hide those row with zero value ?

       

       

      Hope some one can share with me.

       

       

      Paul