I have created a Numeric Formula Field called [IYR (final)] that I need to look at one field - [IYR], and see if there is a value. If there is a value it needs to return it [IYR]. If there is no value "null", I need it to return the value from another field - [IYR (calculated)].
[IYR] is numeric - user input, [IYR (calculated)] - Numeric Formula field
Here is what I wrote that is not working. It only returns the [IYR] value, nothing when the [IYR] is empty.
What am I doing wrong?