Payment report how to remove those row with null value ?

paulyeo11 — Wed, 06 Jul 2016 07:38:40 GMT

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

Re: Payment report how to remove those row with null value ?

paulyeo11 — Wed, 06 Jul 2016 07:40:11 GMT

my qvf