I need to perform a calculation. I need to subtract a date in the current row from the previous row and use the result in a division.
I have another calculated field that that is the DIFFERENCE (in kilometres).
The new value is calculated as follows:
DIFFERENCE / (This rows DATERECEIVED - Previous rows DATERECEIVED)
Please see the attached sample data