Total field of multiple picklists

[eankerson]

Hi.  I am trying to figure out a formula to add up picklist fields to give me a total number.  I have 6 different fields with a choice of 0,10,15,or 20% and I want to be able to add up all those and put the total into a new Probablilty Total field.  I was working with this formula below and it saves but when I go to the page its won't total up and just gives me an error message.

VALUE(text(Competition__c))  +  VALUE(text(Decision_Maker__c))  +  VALUE(text(Decision_Timeline__c))

What am I doing wrong?

[s_k_a]

Hi,

the formula you created, you are converting picklist value into text and adding text values. sothat it wont work.

You can try like this, it would work.

Create a formula filed of number type.

Use CASE function for calculation.

ex:

CASE(Competition__c,0,0,10,10,15,15,20%,0.2)+

CASE(Decision_Maker__c,0,0,10,10,15,15,20%,0.2)+

CASE(Decision_Timeline__c,0,0,10,10,15,15,20%,0.2)+