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

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

Expression

Accepted answers

MarqueeCrew

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

All comments

MarqueeCrew

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].

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335