Find your content:

# decimal places and text() formula

When I use the text formula, salesforce doesn't respect my decimal place formatting. For example,

Field A has 4 places to the right of the decimal. It shows up nicely on the page as 0.4000

If I'm generating a complex string based on the field, I might want to have a formula field equal to:

"The price is \$" & text(Field_a__c) & ", buddy."

Unfortunately, this produces, "The price is \$.4, buddy."

Attribution to: Shane McLaughlin

# Possible Suggestion/Solution #1

Here's the trick. You have to

1. take the "whole numbers" portion
2. Round down
3. add the decimal places using text
4. subtract to get the decimal portion
5. multiply that by 10^[how many digits you want to force]
6. pad the left hand side of the digits after the decimal point with zeroes to add up to the number of decimal places you need

text(floor(Field_a__c)) &"."& lpad(text((Field_a__c-floor(Field_a__c))*100),2,"0")

In this example, you'll get output like "157.50" if your number is 157.5, "147.00" if your number is 147, and "127.01" if your number is 127.01.

Attribution to: Shane McLaughlin
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/5026

My Block Content