If you explore the GetNthRecord() function I think you should be able to accomplish your objective. You may, however, need to wrap it in a Case statement to cover the first or last row situations and generate a meaningful result; ie where the Nth record won't have any data -- because that particular Nth record does not exist!
Message was edited by: John Wolff
One way would be to lookup the start time from the previous record, using a self-join relationship. Note that modifying an existing duration would require a relookup in all subsequent records.
Another option is is to record the duration only and add the running summary to an overall start time.
I would stay away from an ustored cascading calculation, unless your schedules are really short.
Message was edited by: Michael Horak
Thanks for replying! I will try and post the result
Thank you! At the moment stuck in general beginner hickups. First day with FM