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
ChayceDuncan2's avatar
ChayceDuncan2
Qrew Cadet
6 years ago
Try swapping out isnull() with a Nz() function. IsNull can have some weird behavior with 0 versus actual nulls. Nz() will force the value to read as 0 and you can compare to that.

So like:

If(Nz([Actual])=0, [Estimated], [Actual])

Chayce Duncan | Director of Strategic Solutions
(720) 739-1406 | chayceduncan@quandarycg.com
Quandary Knowledge Base