IF THEN formula replacing 0 instead of string

[jpavlick]

In my data set, I have a list of entities with tax ID's and tax ID type. Some of the Tax ID's were not provided and that field was left blank. I am trying to use IF THEN in the formula tool. When the Tax ID is null I want to replace the associated tax ID type with "Unknown" but it keeps being replaced with 0 instead. I have attached a picture and a test workflow with test data.

[mot · Accepted solution]

Hi @jpavlick,

If you change the formula to:

IF IsNull([Taxpayer ID]) THEN "Unknown" ELSE [TIN Type] ENDIF

it should work. I hope this helps. Best.