Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Payment report how to remove those row with null value ?

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

1 Reply
paulyeo11
Master
Master
Author

my qvf