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.