
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 20, 2022 12:17 PM
Hey Everyone, Needing help with another if statement. It is not behaving in the manner I am expecting.
I have 3 fields Odo calculated (Formula Field), Odo miles (Number field) and Final Odometer (If statement). I am trying to have the Final odometer field populate with the odometer calculated field if the odometer overwrite field is empty. If the Odometer Overwrite field is not empty I want that number to populate in the Final Odometer field.
I currently have
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 20, 2022 10:07 PM
That formula looks fine. What's wrong with it? Could you provide some screenshots?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 20, 2022 10:07 PM
That formula looks fine. What's wrong with it? Could you provide some screenshots?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 21, 2022 05:21 AM
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:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 21, 2022 06:04 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 21, 2022 06:09 AM
Hi I tried this equation and unfortunately it did the same thing I am experiencing with my equation.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 21, 2022 06:58 AM
Oh, because it’s not empty, it’s 0.
IF({ODO Miles}>0, {ODO Miles}, {Odo Calculation}).

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 11, 2023 07:58 AM
Strange but the formula ended up working a few days later with no changes. Must of been a glitch
