Formula Tool Returning 0 or -1 instead of String Text based off Conditional If Statement

[Jmills040]

I am trying to get the ACTION_REASON_DESCRIPTION field to return Terminated, Retired, or Death, based off the conditional IF Statement Below. The Data Type is V_W String, yet the output is returned as either 0 or -1. I have tried every string data type possible and the output remains 0 or -1. I do not understand why I am getting this output rather than what I specified in my Formula Tool Expression.

If StatementOutput Field and Data TypeWhat is being returned

[MarqueeCrew · Accepted solution]

IF 
[Employee_Status] = 'T' THEN 'Terminated'  ELSEIF
[Employee_Status] = 'R' THEN 'Retired'  ELSEIF
[Employee_Status] = 'D' THEN 'Death'  
ELSE
Null()
ENDIF

very close!  You don't need to specify the new variable in the syntax.

Thanks,

Mark

[ashissanpui]

This formula should be written to the specific field. In this particular example, the field name should be [ACTION_REASON_DESCRIPTION].

[dipika07011988]

You can specify column name as in the attached image by selecting column drop down and selecting add column