How to hide row that payment clear before 120 Days ?

[paulyeo11]

Hi All

I have a Table consist of total 9 column. I want to only display those company debt > 120days still not settle .( Only those long over due payment cusotmer )

Meaning if company their payment which is below 120days , i want to hide those row. ( Because they are consider good customer )

Hope some one can suggest to me what i need to add in my expression , in order to achieve my requirement.

Paul

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

Not entirely sure, but may be this?

Sum(Aggr(If(Max(TOTAL <COMPANY_PAY>aging_ar) > 120, Sum(total_ar)), COMPANY_PAY, aging_ar))

[paulyeo11]

Hi Sunny

Wow you are supper good. it is correct.

Thank you very much.

Paul