AnsweredAssumed Answered

Need help with field

Question asked by juan.segovia on Apr 25, 2012
Latest reply on Apr 25, 2012 by juan.segovia
Hi, I'm looking for any ideas on this issue:

I have a calculated field in Clarity 13 that brings a 3 digit number. I need to find a way to associate a letter to those number like an internal type code.

For example:

WHEN
111
THEN
C
WHEN
112
THEN
C
WHEN
124
THEN
C
WHEN
125
THEN
B
WHEN
133
THEN
C
WHEN
134
THEN
B
WHEN
135
THEN
B
WHEN
141
THEN
C
WHEN
142
THEN
C
WHEN
143
THEN
B
WHEN
144
THEN
B
WHEN
145
THEN
A

and so on...

I tried to create a lookup with those associations but its not validating since I'm taking a number value and trying to make it a string.

I'm including the syntax of what I tried with no luck.

Please let me know your ideas on how to achieve this.

Thanks.

Juan

Attachments

Outcomes