Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a Payment report which have 10 customer only 5 customer payment term over due,
Each customer is assign to certain payment term like < 30 days < 60 days etc.
May i know how to add expression at dimension , so that it will list those 5 over due customer ( red color arrow ) and hide those customer payment not yet due ?
Paul Yeo
My QVW
What is the output you are looking for?
Hello!
What is value in TERMS 'COD'?
Maybe this expression:
IF(aging_ar > Keepchar(TERMS,'0123456789'), company_ar,null())
(in this expression you must add logic for 'COD')
+ check option in tab for dimensions 'Suppress When Value is Null'
Hi Manish
I need the report same as the image I posted. Except it hide those row with out red Color arrow
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>
Hi Anton
Thank you very much for your sharing. COD refer to cash on delivery. Meaning they must pay cash when buy.
For those COD customer if have out standing Amount , should be display.
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>
You said you want 5 overdue customers.. Your image is not showing the same.. Please clarify.
Hi Sir
You are right row 4 should hide , since not yet due. So only display 4 row.
Paul Yeo
DIrector
TDS Technology (S) P/L
Whatsapp +65 9326 1804
www.tdstech.com<http://www.tdstech.com>
Are you talking about 4 columns or 4 rows?
I am totally confused.
OK.. understood.. working on it now.