benchwrm11

Finding Difference between a Subset of Records

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

Hello,

 

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.

 

Thanks!

Attachments

Outcomes