13 Replies Latest reply on Mar 23, 2014 3:28 PM by JohnAbenaim

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

    jenh

      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?