Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Amount which are 30 days overdue

I'm trying to make the sum of amounts openstanding (AR) which are more than 30 days overdue.

I have the following formula , where Vervaldag = Due Date and BedragOpenstaand=Openstanding Amount

=Sum({<FactTypeId={5}, ">=$((date(today())-Vervaldag)>30) >}[_BedragOpenstaand])

Can any help.

Thx.

1 Reply
sunny_talwar

May be this

=Sum({<FactTypeId={5}, Vervaldag = {"=Date - Vervaldag > 30"} >} [_BedragOpenstaand])