[SalesForce] Incorrect parameter type for operator ‘&’. Expected Text, received Number (Related field: Formula)

I have Pin field which is a formula field and PIN should be DDMM part of DOB of customer.

I have written a foll formula and it gives error

DAY( Customer_id__r.Date_of_Birth__c )  & MONTH(Customer_id__r.Date_of_Birth__c)

and the error is

Incorrect parameter type for operator '&'. Expected Text, received Number (Related field: Formula)

Can some one help pls

Best Answer

The & concatenation operator expects the left operand and right operand to be text. But DAY(Customer_id__r.Date_of_Birth__c) returns integer and so throws syntax error.

You can surround the DAY and MONTH functions with TEXT() function like

TEXT(DAY(Customer_id__r.Date_of_Birth__c)) & TEXT(MONTH(Customer_id__r.Date_of_Birth__c))

Hope it helps.

Related Solutions

[SalesForce] Formula using INCLUDES function – how to reference merge field

When using the INCLUDES funtion, you have to use literal text. See help docs tip below:

Tips: The text_literal expression must be of type text and enclosed in quotes. It cannot be a merge field or the result of a function. Salesforce returns an error if any of the following occurs: You do not provide a text_literal expression. You provide an empty text_literal expression, such as "" or " ". Use ISBLANK to determine if a multi-select picklist field is empty. Use the PRIORVALUE function inside the INCLUDES function to check if the previous value of a multi-select picklist field included a specific value. For example: INCLUDES( PRIORVALUE(multiselect_picklist_field), text_literal )

[SalesForce] Nested If Statment Formula field for Text fields

IF( 
AND( OppRegion__c = "EMEA", 
IF(Account_Country__c = "Azerbaijan","Middle East", 
IF(Account_Country__c = "Bahrain", "Middle East", 
IF(Account_Country__c = "Iraq", "Middle East", 
IF(Account_Country__c = "Israel", "Middle East", 
IF(Account_Country__c = "Jordan", "Middle East", 
IF(Account_Country__c = "Kuwait", "Middle East", 
IF(Account_Country__c = "Lebanon", "Middle East", 
IF(Account_Country__c = "Palestine", "Middle East", 
IF(Account_Country__c = "Qatar", "Middle East", 
IF(Account_Country__c = "Saudi Arabia", "Middle East", 
IF(Account_Country__c = "Turkey", "Middle East", 
If(Account_Country__c = "Russia", "Russia", 
If(Account_Country__c = "Russian Federation","Russia", 
If(Account_Country__c = "UAE","Middle East", 
If(Account_Country__c = "United Arab Emirates","Middle East", 
IF(Account_Country__c = "yemen", "Middle East"), 
If( AND( OppRegion__c = "APAC", 
IF( CONTAINS( Account_Country__c, "China"),"China", 
If(Account_Country__c = "Japan","Japan", 
If(Account_Country__c = "JP","Japan", 
If(Account_Country__c = "Macau","China", 
If(Account_Country__c = "Vietnam","Vietnam", 
If(Account_Country__c = "KR","South Korea", 
If( CONTAINS( Account_Country__c, "Korea","South Korea"), 
IF( OppRegion__c = "NAM", "North America", 
IF(OppRegion__c = "ROW", "SOUTH AMERICA","Other"))))))))))))))))))))))))))))

I think the problem is in IF(Account_Country__c = "yemen", "Middle East") where only two parameters are passed. Remove the closing )

Best Answer

Related Solutions

[SalesForce] Formula using INCLUDES function – how to reference merge field

[SalesForce] Nested If Statment Formula field for Text fields

Related Topic