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.