You need to sign in to do that
Don't have an account?
Mariem Mejrissi
formula field with symbol
Hello everyone!
VALUE(TEXT( FLOOR(heure_fin__c - heure_debut__c) ) & TEXT( ROUND(MOD((heure_fin__c - heure_debut__c)*24,24),0)) & TEXT( ROUND( MOD((heure_fin__c - heure_debut__c)*1440,60) ,0)))
I create this formula field to calculate the number of days, hours and minutes But I want to separate them by a symbol like ","
What must be the solution here?
VALUE(TEXT( FLOOR(heure_fin__c - heure_debut__c) ) & TEXT( ROUND(MOD((heure_fin__c - heure_debut__c)*24,24),0)) & TEXT( ROUND( MOD((heure_fin__c - heure_debut__c)*1440,60) ,0)))
I create this formula field to calculate the number of days, hours and minutes But I want to separate them by a symbol like ","
What must be the solution here?
It looks like our team of experts can help you resolve this ticket. We have Salesforce global help-desk support and you can log a case and our Customer Success Agents will help you solve this issue. You can also speak to them on live chat. Click on the below link to contact our help-desk. Trust me it is a support service that we are offering for free!
https://jbshelpdesk.secure.force.com
Thanks,
Jarvis SFDC team
you can use RPAD to so so
Field Name: Padding with a Character
RPAD(Name, 15, 'z') returns “mycompany.comz”
RPAD(value,LEN(value),what you want to append(in our case it's comma(,))
Let me know if it works
If you found it helpful mark this as best answer.
Warm Regards,
Ram Chand
#StayHomeStaySafe