1 Reply Latest reply: Mar 2, 2017 11:27 AM by Sunny Talwar RSS

    Calculating Amount which are 30 days overdue

    Jean-Pierre Vanden Bosch

      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.