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
Rick SF AdminRick SF Admin 

Adding text to the end of the value of a formula (text) field

I have a custom formula text field using the formula shown below. The output from this formula gives me what I need for the most part, except now I'm trying to add the letter "M" to the end of the value in that field (i.e. $23.5M). I've tried adding the "M" to the forumla following other documentation but no luck. What am I missing?  
CASE(LEN(TEXT( Revenue__c )), 
1, TEXT(Revenue__c), 
11, '$'+TEXT (ROUND(Revenue__c /1000000, 1)),
10, '$'+TEXT (ROUND(Revenue__c /1000000, 1)),

TEXT(LEN(TEXT( Revenue__c ))) 
)
Best Answer chosen by Rick SF Admin
Steven NsubugaSteven Nsubuga
CASE(LEN(TEXT( Revenue__c )), 
1, TEXT(Revenue__c) + 'M', 
11, '$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',
10, '$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',

TEXT(LEN(TEXT( Revenue__c ))) + 'M'
)

 

All Answers

Steven NsubugaSteven Nsubuga
CASE(LEN(TEXT( Revenue__c )), 
1, TEXT(Revenue__c) + 'M', 
11, '$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',
10, '$'+TEXT (ROUND(Revenue__c /1000000, 1)) + 'M',

TEXT(LEN(TEXT( Revenue__c ))) + 'M'
)

 
This was selected as the best answer
Rick SF AdminRick SF Admin
Thank you.