Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
=Sum({<FactTypeId={5}, Vervaldag = {"=Date - Vervaldag > 30"} >} [_BedragOpenstaand])