+ Start a Discussion
NK ShaNK Sha 

Need an formula field of text and display Consultant id and dash seperated with control degits

Hello Team
I am new to Salesforce and i was struck with the Requirement  
Need an formula field of text and display Consultant id and dash seperated with control degits
<9876543210>  -  Control Degit ( two decimul Places)

Regards
NK Sha
Harsh Chandra 23Harsh Chandra 23
Hi Sha,

Are these values i.e "Consultant id" and "Control Degit" directly coming from a field where you want to create formula field? If yes, create a new text formula field and paste below:

'<'+Consultant_Id__c+'>' + ' - ' + Text(round( Control_Degit__c ,2))

Thanks,
Harsh
Ganesh Hembram 21Ganesh Hembram 21
Hi NK Sha,

Could you please explain your requirement little bit more.
What is Consultant Id and Control Degit - Both are different fields in the same object?

Thanks & Regards,
Ganesh Hembram
NK ShaNK Sha
Hi Ganesh 
Consultant id Is an Field and the Control Degit Means MOD (that is should always consist of 2 digits.)
Ganesh Hembram 21Ganesh Hembram 21
Hi NK Sha,

As @Harsh mentioned create a new text formula field and write the below formula if both the fields are in the same object
IF(Consultant_Id__c<> null, "<" & Consultant_Id__c& ">" & " - " &  TEXT(ROUND(Control_Degit__c,,2) ), 'NA')
Used the "IF" condition because if the Consultant_Id__c is blank/null then the formula field will display NA. 
If the Consultant_Id__c is not blank/null then it will display the concenate value.

Note: Change the formula based on your requirement.

Thanks & Regards,
Ganesh Hembram