+ Start a Discussion
Dana BreakstoneDana Breakstone 

Error: Formula result is data type (Boolean), incompatible with expected data type (Currency).

I have added 3 custom fields to the Opportunity Product section, all of which are set to currency and have a 14 character limit with 4 decimal places. I am trying to build a 4th formula with the following to equal "total price" (also a currency with the above):

Dollar_GB_Cost__c  *  Standard_Price__c  =  List_Price__c

What am I doing wrong here? I am new to salesforce and trying to mess around with opportunity pricing based on a cost (usually in the $.50 range) x standard cost = list price/sales price.
 
Akhil AnilAkhil Anil
Hi Dana,

Your formula would be simply this
 
Dollar_GB_Cost__c  *  Standard_Price__c

 
Nishad KNishad K
Hi Dana,
Please make sure you formula field is currency type,

and use the below formula :  

Dollar_GB_Cost__c  *  Standard_Price__c
 
Regards,
pranav shah 40pranav shah 40
Dear All, 

I am trying to update the Field "Amount" using workflow rule on Opportunity object
 but i am getting following error for the same
Error: Formula result is data type (Boolean), incompatible with expected data type (Currency).

I am using this
Amount=12000.00

How i can set the value on amount ...please help me out