You need to sign in to do that
Don't have an account?
Robbi 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!
EX: Picklist 1 = 4 and Picklist 2 = 8, resulting product = 32
Can this be done? If so, how?
Thank you for your help!
VALUE( TEXT(picklist1__c) ) * VALUE( TEXT(picklist2__c ) ) and make the formula field of type number
All Answers
VALUE( TEXT(picklist1__c) ) * VALUE( TEXT(picklist2__c ) ) and make the formula field of type number
Here Api name of picklist 1 is p1__c and picklist 2 is p2__c.
Use this as a source for your funnel graph