I have a problem I hope someone can help me solve. I have a table that I log the odometer miles of my motorcycle into every time I have a service or issue with the bike. I would like to create a report that shows the average miles in between issues, but I'm not sure how to go about it.

Any ideas?

I think you can just compute this by dividing the total miles travelled by the number of issues. Depending on your structure, this could be done using the average () function

If you have a line items file for issuesm then: Average ( Issues::OdometerPosition)

To get the miles difference between records, you can try a calculation with:

Miles - GetNthRecord ( Miles ; Get ( RecordNumber ) -1 )

Then create another calc field or summary field that averages the first calc.

This is pending the premise that your records are created with the miles always increasing as well as displaying all the records. If not, then you can use a self join to get around it.

Thanks,

That worked.

Darron