ADD LETTER TO FIELD BASED ON FORMULA 1

[BoeingSK]

I need to add letters to a field based on a conditional formula is this possible? This is what I have please tell me where I am going wrong.

IF {Command.DOC_CATEGORY}="SO" THEN 'S{Command.DOC_CATEGORY}'
ELSE IF {Command.DOC_CATEGORY} = "RF" THEN 'R{Command.DOC_CATEGORY}'

I want the field to show as either S4000 or R4000 based on which category it is in.

Up and Coming Technical Guy

 

[AndyMc]

Try:

IF {Command.DOC_CATEGORY}= "SO" THEN
"S" & {Command.DOC_CATEGORY}
ELSE IF {Command.DOC_CATEGORY} = "RF" THEN
"R" & {Command.DOC_CATEGORY}


Andy

 

[BoeingSK]

That was perfect, thank you! I'll be glad when the day comes that i can answer some of the questions.

Up and Coming Technical Guy