14 Replies Latest reply on Jul 7, 2017 5:41 PM by bigtom

    How to get the percent difference between 2 numbers of 2 consecutive years?




      I'm trying to convert a simple excel file containing balance sheet of different companies into a filemaker  file and hit upon this problem.


      The data is

      Company, Year, Asset,

      CompanyA, 2000, 10000

      CompanyA, 2001, 20000

      CompanyA, 2002, 21000

      CompanyA, 2003, 50000

      ComapnyB, 2000, 2000

      CompanyB, 2001, 1000

      CompanyB, 2002, 500


      The formula is

      (A-B)/A * 100%


      In Excel, its very easy to select a cell and have it calculate the solution.


      In Filemaker, I don't know how to get the number of the first year to use for the second year.


      Is this possible in Filemaker?


      Thank you!