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
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>
This one is also looking wrong to me.. Kindly check and confirm.
KAI COMMUTER JABODETABEK,
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>
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))
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))
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>
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