Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Terry_0101Terry_0101 

Multiply two numbers

I'm trying to multiply two formula fields with numbers, but these are text data type, since the orginal fields are picklist.

Here is the error when I try to create a new formula field and multiply both fields:

Error: Incorrect parameter type for operator '*'. Expected Number, received Text
surasura
use the VALUE(your_field) to convert your text field  to the number 
Prosenjit Sarkar 7Prosenjit Sarkar 7
Hi Samantha,
I think you dont need to multiply those formula fields. You can use this also
VALUE(TEXT(Pick_List_1__c)) * VALUE(TEXT(Pick_List_2__c))