1 Reply Latest reply: May 8, 2018 4:01 AM by Bram Knuever RSS

    How to calculate and show debt by year.

    Pascal Schwegler

      Hi Community,

       

      I would like to create a line chart which shows the debt over the years.

       

      My data is as follows:

       

      Debts

      DATE, DESCRIPTION, AMOUNT

      31-12-2015, Debt I, 10.000

       

      Debt repayments

      DATE, AMOUNT

      31-12-2015, 1500

      31-12-2016, 1300

      31-12-2017, 1100

      31-12-2018, 900

      31-12-2019, 700

       

      Expected result:

      debt 31-12-2015 = 10.000

      debt 31-12-2016 = 8.500 (10.000 minus 1.500)

       

      How do I have to make this to put it in a line chart?

       

      Thank you in advance!