2

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 '15 at 10:54
6

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

VALUE(TEXT(Field_Price__c))

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.