Discussions

Expand all | Collapse all

Subtracting

  • 1.  Subtracting

    Posted 22 days ago
    I'm sure that the fix is easy but I'm having a brain fart tonight.


    I'm looking to get a total amount of miles driven.   The user enters their starting and ending miles in a numeric box and I need to tell the program to subtract the ending miles from the starting miles to get a total driven.



    Any thoughts?


    Thanks

    ------------------------------
    Matthew Imrie
    ------------------------------


  • 2.  RE: Subtracting

    Posted 22 days ago
    Assuming that you have two separate numeric fields on the same record, one for the starting mileage and one for the ending mileage, then Quick Base is exactly the same as Excel. 

    Make a formula numeric field and use the formula

    [Ending Odometer] - [Starting Odometer]


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------