+ 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.