AnsweredAssumed Answered

Calculating the difference between two successive records

Question asked by JeromeSimons on Aug 6, 2013
Latest reply on Aug 7, 2013 by JeromeSimons

Title

Calculating the difference between two successive records

Post

     Dear All,

     I wish to introduce a new field that calculates the difference in days between two dates. The table would hold disbursements which are identified by a grant ID and a disbursement number (1st 2nd etc.).

     I have seen the excellent example Calculation between 2 records in same table. that talks about how to calculate values within one field but could not figure out how to use the table occurences and sorts in a manner that would actually display the difference between two successive records. From what I have, I get the number of days elapsed since the earliest date as can be seen in the screenshot. I would, however, need the number of days elapsed since each successive disbursement.

     I would greatly appreciate your help.

     Best,

     Jerome

screen.jpg

Outcomes