+ Start a Discussion
Robbi ConverseRobbi Converse 

Formula needed to multiply the value of a picklist field by the value of another picklist field

I have two custom picklist fields (both fields are a range of numbers). My customer wants a funnel graph of the product of the selected values of these two fields.
EX: Picklist 1 = 4 and Picklist 2 = 8, resulting product = 32

Can this be done? If so, how?

Thank you for your help!
Best Answer chosen by Robbi Converse
badibadi
Try this

VALUE( TEXT(picklist1__c) ) * VALUE( TEXT(picklist2__c ) ) and make the formula field of type number 

All Answers

badibadi
Try this

VALUE( TEXT(picklist1__c) ) * VALUE( TEXT(picklist2__c ) ) and make the formula field of type number 
This was selected as the best answer
Ankit SehgalAnkit Sehgal
Create a formula field with return type number with following formula: ​VALUE(TEXT(p1__c )) * VALUE(TEXT(p2__c ))

Here Api name of picklist 1 is p1__c and picklist 2 is p2__c.

Use this as a source for your funnel graph