ShowAll Questionssorted byDate Posted
Jill Heffernan

# I would like to update a fied based on the value selected in a picklist

I have a picklist field with about 10 options. Each option should correspond to a specific % number.  What is the best way to have a field update with the correct % based on the picklist option selected?
Example:
Option A should update new field with 10%
Option B should update new field with 20%
Option C should update new field with 30%
Etc....
Best Answer chosen by Jill Heffernan
Chris Gardner

Does it need to actually write data to a new field, or can you use a formula field for the percentages?

If you can use a formula, a CASE statement should work well:

```CASE({!Custom_Field__c},
"Option A", 10,
"Option B", 20,
"Option C", 30,
...
0)```

Chris Gardner

Does it need to actually write data to a new field, or can you use a formula field for the percentages?

If you can use a formula, a CASE statement should work well:

```CASE({!Custom_Field__c},
"Option A", 10,
"Option B", 20,
"Option C", 30,
...
0)```
This was selected as the best answer
Umair Javaid
Hi Jill,

You could create a formula field with the type of Percent and use the following formula:

```CASE(Picklist_field__c,
"Option A", 0.1,
"Option B", 0.2,
"Option C", 0.3,
...
"Option J", 1,
null)```

Steve Molis
What is the datatype of the other field?

Is it a Datatype = Percent?
or is it a Datatype = Formula with a Percent result?

Your basic Formula would be something like this

```CASE(Option ,
"A", 0.10,
"B", 0.20,
"C", 0.30,
"D", 0.40,
"E", 0.50,
"F", 0.60,
"G", 0.70,
"H", 0.80,
"I", 0.90,
"J", 1.00,
0)```

Jill Heffernan
Thank you! This formula worked, just needed the correct percent in the field.
Steve Molis
PS.  Percent values are stored as decimals, not whole numbers.

For example
0.10 = 10%
1 = 100%
10 = 1,000%