5 Replies Latest reply on Jan 19, 2015 10:19 PM by stevedaraska

    Field that shows % change in 2 consecutive records for the same client

    stevedaraska

      Title

      Field that shows % change in 2 consecutive records for the same client

      Post

      I am using filemaker 11.  If I have table set up to assess a clients bodyweight progress over time, how do I set up a field which tells me the % change from their previous reading?  

      Currently I have ClientID set as the key field with the other relevant fields in the table being Assessment Date and Body Weight.

      Any help is much appreciated