Value List Value verus Display

[danb]

Hi, I'm wondering if there's a way to have a value list and for the display of items in the list show one thing (for example: 25%, 50%, 75%) and then separately set the stored content that the user doesn't see (for example: 1.25, 1.50, 1.75) - as you can see I need to do calculations on a percentage

Think of it as an HTML <select> list, in which you can independently set the label and the content. Is this possible in FM 5?

Thanks...

[BobWeaver]

You can use a calculated field, ScaleFactor, based on the Percentage field such as:

ScaleFactor = 1 + (NumToText(Substitute(Percentage,"%","")) / 100)

and just use ScaleFactor in your subsequent calculations