AnsweredAssumed Answered

Calculating a percentage change

Question asked by pdoak_1 on Jan 18, 2011
Latest reply on Jan 18, 2011 by pdoak_1


Calculating a percentage change


Background Info: I am using the following

  1. Filemaker pro Advanced 11
  2. Mac OS X 10.6.6
  3. Single user mode
  4. I have been using Filemaker Pro for a few of months

I have a table which consists of the following fields:

Date, AccountNo, Balance

This table gets updated daily with the balance for each account.  I wish to create a report which calculates the percentage change in a client's account balance from a particular date, which I set in another table as a global variable, to the current date i.e. the latest record.  What is the best way of achieving that.  I am struggling with obtaining the account balance for each client based upon the global variable date.  Once I can do that the calculation is easy!