Another pair of eyes on a simple If Then Statement

[mattlukoff]

Hi, can anyone take a look at this. Not understanding why I'm not getting the desired output.

Thanks

[Joe_Mako · Accepted solution]

How about the attached?

I removed the NOT operator ! and set the data type to Int32 for all fields.

[Federica_FF · Accepted solution]

Hi, I think you may want to remove the exclamation point.

Right now you're telling the formula tool:

IF !ISNull([Key 1]) then [Right Key 1]
// if NOT is null Key1 then Right Key

Else Null()
// else Null()
ENDIF

Key1 is actually null, so you're getting the "else" part of your IF statement.