Fuel Calculation

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Fuel Calculation

Viewing 1 reply thread
  • Author
    Posts
  • June 12, 2018 at 10:32 AM #29049

    Eddzo
    Participant

    Hi Everyone,

    I did a search and came up short.
    I’m trying to capture my fuel cost data.

    Is there a way to Subtract Odometer reading from one date to the other date for a calculation?

    Trying to think how to ID the date or line in a formula but I’m short circuiting in the brain… lol

    Attachments:
    You must be logged in to view attached files.
    June 12, 2018 at 6:03 PM #29054

    Brendan
    Keymaster

    Hi Eddzo,

    The issue is you can’t reference the previous record (whatever that may be) from a formula. So you’ll need to just copy the previous day’s odometer reading to the new record and then have Tap Forms calculate the difference between that and the current odometer reading.

    So maybe add a Previous Odometer field as well as your regular Odometer field so you’ll have both the previous day’s and current day’s value that you can use for the calculation.

    Thanks,

    Brendan

  • Author
    Posts
Viewing 1 reply thread

You must be logged in to reply to this topic.