How to hide row for those customer their payment not yet due ?

[Paulyeo11]

Hi All

https://www.dropbox.com/s/ptlur9lwzo921sp/AR_ISDN%20v009%20trail%20how%20to%20not%20display%20pay%20...

[amitchandak · Accepted solution]

@Paulyeo11 , one way is to have a measure like

Measure = sumx(filter(AR,Datediff([AR Invoice Date],today(),day) >30 ),[A/R amount include GST in LC])

That will show only the overdue amount. File Attached.

[amitchandak · Accepted solution]

@Paulyeo11 , one way is to have a measure like

Measure = sumx(filter(AR,Datediff([AR Invoice Date],today(),day) >30 ),[A/R amount include GST in LC])

That will show only the overdue amount. File Attached.

[Paulyeo11 · Accepted solution]

This is what I am looking for 

[ryan_mayu]

@Paulyeo11 

just like what @collinq  sugggested. you can only select 030 DAYS in hte Filters.

[collinq]

Hi @Paulyeo11 ,

I think that the easiest way would be to add into the filter a "greater than 30" on that field so only items greater than 30 will appear.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!