That formula looks fine. What's wrong with it? Could you provide some screenshots?
ODO Miles = Odometer Overwrite, yes? If so, then what you currently have - IF({ODO Miles} = " ", {ODO Miles}, {Odo Calculated}) - says “if the overwrite is empty, use the overwrite, otherwise use the calculation.”
What I think you want is the opposite:
IF({ODO Miles} = " ", {Odo Calculated}, {ODO Miles})
or
IF({ODO Miles}, {ODO Miles}, {Odo Calculated}).
That formula looks fine. What's wrong with it? Could you provide some screenshots?
Adam,
Please see a screenshot. As you can see the calculation field Odo calculated shows since the Odo Miles is empty but where the odo miles is empty.
ODO Miles = Odometer Overwrite, yes? If so, then what you currently have - IF({ODO Miles} = " ", {ODO Miles}, {Odo Calculated}) - says “if the overwrite is empty, use the overwrite, otherwise use the calculation.”
What I think you want is the opposite:
IF({ODO Miles} = " ", {Odo Calculated}, {ODO Miles})
or
IF({ODO Miles}, {ODO Miles}, {Odo Calculated}).
Hi I tried this equation and unfortunately it did the same thing I am experiencing with my equation.
Hi I tried this equation and unfortunately it did the same thing I am experiencing with my equation.
Oh, because it’s not empty, it’s 0.
IF({ODO Miles}>0, {ODO Miles}, {Odo Calculation}).
That formula looks fine. What's wrong with it? Could you provide some screenshots?
Strange but the formula ended up working a few days later with no changes. Must of been a glitch
