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]

Hi Manish

I refer row , but the expression check on column. Because every column indicate Aging amount.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[MK_QSL]

This one is also looking wrong to me.. Kindly check and confirm.

KAI COMMUTER JABODETABEK,

[paulyeo11]

Hi Manish

KAI COMMUTER JABODETABEK, you are right , this row don't show. As the payment not yet due.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[MK_QSL]

You can achieve you output by

1) Remove Calculated Dimension

Use below expressions

1) If(aging_ar >= 31 and aging_ar <=60 and TERMS = '<30 DAY', Sum(ar_total))

Label 31-60

2) If(aging_ar >= 61 and aging_ar <= 90 and TERMS = '<60 DAY', Sum(ar_total))

Label 61-90

and so on

For COD

If(TERMS = 'COD', Sum(ar_total))

[devarasu07]

Hi

How do you define whether the customer is over due or not ? (i.e in no of days /aging bucket wise),

by using range expression in set analysis can solve and also conditional statement.

Sum({$<aging_ar = {">=31<=60"} >} ar_total)

or

If(aging_ar >= 31 and aging_ar <= 60,sum(ar_total))

[paulyeo11]

Hi deva

Each customer is assign a payment term day , some 30 day and some 60 day term , The field name TERMS.

So need to set condition to compare Aging day > TERMS days display.

Any idea how to write the expression at dimension ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[paulyeo11]

Hi Manish

Thank you for your suggested exxpression.

I use the below expression , it work fine , it can list out all those Cash term customer listed ( when activate button terms = C )

=If(terms = 'C', Sum(ar_total))

When i try to implement those payment 30 Days customer using below expression , it does not list out those over due customer :-

=If(aging_ar >= 31 and aging_ar <= 60 and terms = '1', Sum(ar_total))

I expected it should list those customer when Button terms = 1 is activated.

Paul