AnsweredAssumed Answered

How to calculate the field value difference from and the prior record.

Question asked by jenh on Jun 10, 2010
Latest reply on Mar 23, 2014 by JohnAbenaim

Title

How to calculate the field value difference from and the prior record.

Post

Hi.  using Filemaker pro 10. 

 

I'd like to add to a report a field that is the difference in a field value from one record and the prior record.

 

 

  Example:

 

  File    Difference

   1

   2           0

   5           2 

   6           0

   10         3 

 

Difference is the field I need to create. 

 

Is this possible as a field calculation?  

Outcomes