Power Platform Community Forum Thread Details

Hi there,

I am trying to assign number values to text choice list selections with the goal of calculating the values of the selections.

For example, I have 2 choice columns Grant Program Value Risk and Value of Grant Risk. Each selection in each of the choice lists has a value given to each label. E.g. if the user selects their grant is less than $10m, then I figure the value of that response is 10. I then want another column to be able to calculate the values of the 2 columns based on their number value. However, I cannot seem to be able to access the number value in a formula - example in the 4th screenshot below.

Is there a way to calculate the choice list responses using their value?

If not, what would be the best way to assign/extract a number value from a text response to use in a later calculation?

Please see images below to assist with the example situation above.