use single select field values in input select

[Tucker_McKenzie]

I would like to pull the value from a single select to use in a formula. For example, i have an opportunity that has a set value as well as a set of percentage of realization. I would like to multiply these two values to get a weighted value. See below for full example:

Project X has a $100,000 opportunity value, with a 70% chance of winning. The weighted value would be $70,000 ($100,000 x 0.70).

[AlliAlosa · Accepted solution]

Try wrapping your single select field names in the VALUE() function :slightly_smiling_face:

For example:

VALUE({Select Field 1}) * VALUE({Select Field 2})

Hope that helps!

[Tucker_McKenzie]

Thanks for this suggestion. I used the VALUE() formula, but it is just returning a 1 or a 0 (if of the single select fields are picked it provides a 1, if none selected it returns a 0).

However … I just checked the formatting and it was set to single integer … so 90% was rounding up … “fixing” the formatting “fixed” my problem, lol. Thanks for making me double check!