How to convert Text to number

[scottbassett]

Hi!
I have a drop down with static choices of Poor, Fair, Good, Excellent and these show up as text in the database. I want to assign a value to them so they can be graphed over time. So Poor would also have a value of 1, Fair would have a value if 3, Good = 5 and Excellent = 7.

Can I create the value in the database or can it be done with a workflow?

Thanks!

[gustavosales0809]

in Data go to Option sets

create a nem option (classification or something like that, the name doesn’t matter)
and create a new attribute, number

now you go to the data types and change what you have now to storage this classification
now will be the classif

this is the easyest way

[scottbassett]

Thank you, that worked!