You need to sign in to do that
Don't have an account?
Rick 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 ))) )
All Answers