Hello

I am new to webfocus and I am not a developer, I am using only infoassist and the report assistant. I have a column (with P6 format), I want to use that column to create a new column with text.
For example
Column A Objective Column
Peter USA
John USA
Kevin USA
Juan Spain
Pedro Spain
Jorge Spain
Jean France
Michel France
Francois France

I have tried to create a define with an if then else condition (IF COLUMN A EQ 'Pedro' OR 'Jorge' OR 'Juan' THEN OBJECTIVE COLUMN EQ 'Spain'

I´ve tried this in the report assistant but I haven´t had any luck. Maybe it is because of the formats or how I am creating the define. Hope somebody here can help me.

Regards

This message has been edited. Last edited by: Kerry,

You are havinh these problems because your field is P6 which is a numeric field.

Thank you so much!!!!!!!!

quote:

IF COLUMN A EQ 'Pedro' OR 'Jorge' OR 'Juan' THEN OBJECTIVE COLUMN EQ 'Spain'

Not to sure about your define either.

Hello.

I am not very familiar with the syntax so I hope this is understandable....here´s what I did...
DEALEREDITED/A8 = EDIT ( DEALER );
SALESSCALE/A8=IF DEALEREDITED EQ '000790' OR '000793' OR '000794' OR '000941' THEN 'SE' ELSE
IF DEALEREDITED EQ '000462' OR '000725' OR '000746' OR '000320' OR '000719' THEN 'QD4'

IT WORKED JUST FINE.....REGARDS....DAVID

I would add an ELSE at the end:
ELSE ' ';
for example