How to suppress row when Total column = zero value for Aging Table

[paulyeo11]

Hi All

How to suppress row when Total column = zero value.

I have already try to check at dimension tab and presentation tab. but still cannot hide.

Paul

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

May be use this expression:

If(Sum(TOTAL <COMPANY_PAY> total_ar) > 0, Sum(total_ar))

[paulyeo11]

Hi Sunny

Thank you very much . it work.,

Paul