Hi:

I'm working on a report where I added a new field that will be populated depending on the value of another field.

Basically I have "Field A" with possible values of: a, b, c and d, and "Field B" that should be populated as explained on the table below:

Field A    Field B      Set Value

a                              Set Field: Field B - Condition: Field A = a  - Set Value = One

b                              Set Field: Field B - Condition: Field A = b  - Set Value = Two

c                              Set Field: Field B - Condition: Field A = c  - Set Value = Three

...

I tried using several Set Value operators as above, but just worked for the first one.

I wonder if is there a way to achieve this task.

Thanks in advance

Enrique