How to display only those over due payment customer ?

[paulyeo11]

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

[paulyeo11]

My QVW

[MK_QSL]

What is the output you are looking for?

[asgardd2]

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'

[paulyeo11]

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>

[paulyeo11]

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>

[MK_QSL]

You said you want 5 overdue customers.. Your image is not showing the same.. Please clarify.

[paulyeo11]

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>

[MK_QSL]

Are you talking about 4 columns or 4 rows?
I am totally confused.

[MK_QSL]

OK.. understood.. working on it now.