Forum Discussion

JordanLyon's avatar
JordanLyon
Qrew Trainee
6 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
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
Jordan, your first formula works for me, but you need to first go to the properties for your "Actual" field an uncheck the box for 'Treat blank values as "0" in calculations'.


  • JordanLyon's avatar
    JordanLyon
    Qrew Trainee
    6 years ago
    Thank you! That fixed it.