RebeccaKnecht__

2 years agoQrew Member

# FOrmulas

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

------------------------------

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

------------------------------