Forum Discussion

JordanLyon's avatar
JordanLyon
Qrew Trainee
7 years ago

If formula that can display value from one of two fields

I need advice on composing a formula for a numeric field.  Basically, I have 3 numeric fields: an "estimated" value (Field A), an "actual" value (Field B) and a "Final" value (Field C). I want to d...
Formulas and functions
JordanLyon's avatar
JordanLyon
Qrew Trainee
7 years ago
That almost works, except, sometimes my "Actual" can be "0". In which case, I would want Field C to display "0". With the formula you provided, Field C is displaying "Estimated" when "Actual" is "0". 

Is there a way around this?