Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SriRamya BeramSriRamya Beram 

IF(RecordType.Name== 'Purchase Order', Name ='po-'+CC_OrderNumber__c-CC_Sales_Order__r.CC_OrderNumber__c , Name ='so-'+CC_OrderNumber__c-CC_Project__r.Name ) Error: Incorrect parameter type for operator '-'. Expected Number, Date, DateTime, received Text

IF(RecordType.Name== 'Purchase Order', Name ='po-'+CC_OrderNumber__c-CC_Sales_Order__r.CC_OrderNumber__c ,
 Name ='so-'+CC_OrderNumber__c-CC_Project__r.Name )
Error: Incorrect parameter type for operator '-'. Expected Number, Date, DateTime, received Text
 
Apoorv Saxena 4Apoorv Saxena 4

Hi SriRamya,

Can you explain what are you trying to achieve ?
and also provide the datatype for CC_OrderNumber__c,CC_Sales_Order__r.CC_OrderNumber__c,CC_Project__r.Name

Thanks,
Apoorv
SriRamya BeramSriRamya Beram

Object Sales Order  
Field to UpdateSales Order: Order Name
Field Data Type:Text


 Formula Value (Text) =
IF(RecordType.Name== 'Purchase Order', Name ='po-'+CC_OrderNumber__c+'-'+CC_Sales_Order__r.CC_OrderNumber__c,
 Name ='so-'+CC_OrderNumber__c+'-'+CC_Project__r.Name)
 
 Error: Formula result is data type (Boolean), incompatible with expected data type (Text).
im tring to update the OrderName(Name)
OrderName is text
Remaining all are AUTONUMBER

 
Apoorv Saxena 4Apoorv Saxena 4
Formula field is a new field that will show value as per your criteria , you cannot update Standard Name field from formula field, for that you will have to use a workflow rule

Please provide the auto number display format for the fields used here, so that I can help you out in achieving the desired functionality.