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.