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

Discussion created by pleiades on Jul 5, 2017
Latest reply on Jul 7, 2017 by bigtom



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!