Field that shows % change in 2 consecutive records for the same client
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