+ Start a Discussion

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
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))