function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RahulRahul 

Hello Friends, Iam selecting 12 from total_tenure__c picklist field and 4 from Advance_EMI__c Field. I want to display scheme field value as 12/4, but its calculating the value as 3. i want to display as it is 12/4. Please find my Formula below

Value(text(Total_tenure__C)/ value(text(Advance_Emi__C)) 

Result should be 12/4  displayed on Scheme field but its display as 3 after calculation. I dont want it to be calculated.
Best Answer chosen by Rahul
Ajay K DubediAjay K Dubedi
Hi Sumit,
Firstly take formula field of text type then apply this formula: 
text(FirstField__c) + '/'  + text(SecondField__c)
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi

All Answers

Ajay K DubediAjay K Dubedi
Hi Sumit,
Firstly take formula field of text type then apply this formula: 
text(FirstField__c) + '/'  + text(SecondField__c)
I hope you find the above solution helpful. If it does, please mark as Best Answer to help others too.
Thanks,
Ajay Dubedi
This was selected as the best answer
RahulRahul
Thanks Ajay :)