Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not entirely sure, but may be this?
Sum(Aggr(If(Max(TOTAL <COMPANY_PAY>aging_ar) > 120, Sum(total_ar)), COMPANY_PAY, aging_ar))
my qvw
Not entirely sure, but may be this?
Sum(Aggr(If(Max(TOTAL <COMPANY_PAY>aging_ar) > 120, Sum(total_ar)), COMPANY_PAY, aging_ar))
Hi Sunny
Wow you are supper good. it is correct.
Thank you very much.
Paul