April 24, 2006, 03:50 PM
Ginnydefine field for MPG
I have a daily fuel log table with an incrementing number, vehicle serial number, odometer reading and the amount of fuel pumped. How can I write a function to tell Webfocus to use the reading of the odometer from the previous fill in my equation?
April 24, 2006, 04:07 PM
reFOCUSingYou will have to sort the data to be in the order you want and then you can use the LAST function.
April 24, 2006, 04:10 PM
reFOCUSingHere is a doc found on the tech support site that shows you how to use LAST.
http://documentation.informationbuilders.com/masterinde...func/datasource4.htmApril 24, 2006, 04:10 PM
GinnyThank you I was just looking at that function