You need to sign in to do that
Don't have an account?
NK 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
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
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
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
Consultant id Is an Field and the Control Degit Means MOD (that is should always consist of 2 digits.)
As @Harsh mentioned create a new text formula field and write the below formula if both the fields are in the same object 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