9 Replies Latest reply: Jul 28, 2016 3:23 PM by PAUL YEO RSS

    Expression surpress null value work in QV but not work in QS.

    PAUL YEO

      Hi All


      I have below expression from Sunny working fine :-


      Only({<SEGMENT -= {'Related Coy'}>} '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')

       

      But when i use the same expression in QS , i am unable to surpress the null row. ( it work fine in QV )

       

      Paul