How to Omit Zeros from the Straight table

[muhammedraleen]

Hi All,

I have attached a straight table, which shows you some total is zeros. I need to omit rows which has a sum of zero. 

I have taken balance due column as Sum(DocTotalFC)-Sum(PaidFC),  I cannot control from load editor because the balance due gets incorrect figures.

As of now, Figures are correct. Just only need those rows omitted which has balance due as zero.

 

[micheledenardi · Accepted solution]

Remove "Include zero values" from Add-ons object tab 

[Ajith_1997]

Hi @micheledenardi ,

Thank you for your kind and quick support.