function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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