Is there any way to grab data from the previous row, same data field? For example in the data below:
Vehicle Tag # Wk st dt Wk end Dt End Miles Prev End Miles
abcde 5/5/11 5/11/11 10,100
abcde 5/12/11 5/18/11 10,500 10,100
Is there any way to grab the 5/5...
I am trying to calculate total miles for a vehicle by taking the odometer reading from the current week and subtracting the odometer from the prior week. The problem I am having is that the data is in a list report and each week is a row of data. Do you have any ideas on the best way to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.