IF statement inserts 0

marcin2x4

I wrote a simple if statement:

IF [Party Office] = "GULFESTMED"
THEN  [Party Office] = "Gulf East Med"
ELSE [Party Office]
ENDIF

Instead of text it inserts value 0 to the attribute. Input format of the field is V_String.

Should I set up a different format ?

rahul1011

Since you are already selecting the field on which you are using the formula, you don't need to add it in the then section.

Try the below:

IF [Party Office] = "GULFESTMED"
THEN  "Gulf East Med"
ELSE [Party Office]
ENDIF