I have Three fields one is multipicklist(type of room - A/c, non a/c, icu) and another one is picklist(price - 1000, 2000, 3000) and Total Amount

type of room and price are dependent fields (Ex: if i select a/c, the price has to be 2000 etc.,)

My question is :

I need a formula for (Total amount = type of room * price)

When i use like this is giving the error as

Error: Field Price__c is a picklist field. Picklist fields are only supported in certain function

  • Hi Mohan, welcome to Salesforce Stackexchange!
    – martin
    Sep 18, 2015 at 10:54

1 Answer 1


In order to get a number out of your pick list value you need to use a few functions. The TEXT() function will pull the number from your pick list in text format, and then use the VALUE() function to convert that to a number


If your other fields are also pick lists, you will need to use this method as well.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .