1 Reply Latest reply: Jul 6, 2016 3:40 AM by PAUL YEO RSS

    Payment report how to remove those row with null value ?

    PAUL YEO

      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.

       

      Paul