1 Reply Latest reply: Jul 6, 2016 3:40 AM by Yeo Poh sai RSS

    Payment report how to remove those row with null value ?

    Yeo Poh sai

      Hi All


      My payment table only 7 row have data , and balance 100 row with null value.


      In order to remove null row , i need to use Below expression is working fine :-

      if((Sum(curren)+Sum(days3)+Sum(days6)+Sum(days9)+Sum(above12))<>0, COMPANY_PAY, '')



      it should remove those row when curren field value = 0


      But it does not work.


      Can some one advise me ?


      Remark in QV it work fine but now in QS.