Finding Difference between a Subset of Records

Discussion created by benchwrm11 on Aug 29, 2012
Latest reply on Aug 30, 2012 by benchwrm11



I have a database of animal locations. Right now I have each individuals ID and their absolute location for each relocation (1 to 5 relocations per individual). I would like to calculate distance moved from last location (abs(location-location.last)) for each relocation. For clarity, I've inclued an example of what I have with a few entries.


Any suggestions on how to code the calculation? I have been trying


Let ( [n = Count ( ID)]; GetNthRecord ( Entry_Distance ; n ) - GetNthRecord ( Entry_Distance ; n - 1 ))


but I'm not having any luck (all fields are ?). Any advice would be greatly appreciated.