Skip to main content
Question

FOrmulas

  • August 16, 2022
  • 0 replies
  • 43 views
Having trouble getting a formula to do what i want.

I want to add up the following items, but one of the items is already a formula and I when i out it in the formula to get a total unless that one has a number no total shows. How can I get the formula to say if nothing is in that spot to just assume its zero.

example: Hotel expenses + Flat rate + Mileage Cost total = Total

Mileage cost total is a numeric formula that is If([Mileage] >15, [Mileage Cost]). Hotel expenses and flat rate are both just numbers type into the field. Hoept his makes sense. Any duggestions are welcome

------------------------------
Rebecca Knecht, MS, ACSM-CEP
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    np,
    Just go to the field properties for each field and check the box called "Treat blank as zero"

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement