Define Drop-Down list of integers
One answer
There is an attribute type Integer that you can use for integers. There is no option to make that a drop down selection. You have to type the integer.
I do not think Excel cares about the type, it cares a bout the representation. If you want a drop down, you have to use an enumeration.
If you want to use an enumeration, carefully test on a test machine, what gets exported. I think it is the (string)value of the enumeration.
You can also define an enumeration in a way, where the literal ID is represented by a number, and the display value looks a bit different. In order to get the result like below, you have to define the enumeration literals and then go into the process configuration source to manually modify the enumeration literal ID values to what you desire. As an example look at the built in complexity
Comments
Hi Ralph,
Pnina
I don't understand, why you asked your original question, if you have a totally different question. Have you tried to export to Excel? Maybe you can use macros to remove the PTS in the value? Otherwise my original answer holds and you could create a new complexity attribute of type integer or enumeration and define that without the pts and select it as complexity attribute.
Hi, I finally used your original answer and it worked well. Thank You!
Then please accept the original answer.