function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mariem MejrissiMariem 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? 
firdoss mohd 1firdoss mohd 1
Hi Mariem,

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!

Jarvis SFDC team
Ram Chand HeerekarRam Chand Heerekar
Hi Marlem,

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