3 Replies Latest reply on Aug 30, 2012 7:48 PM by benchwrm11

    Finding Difference between a Subset of Records

    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!