Definition
Decimal Places is a configuration property on Number and Currency fields that specifies how many digits are allowed after the decimal point (0-18). The setting determines both the precision of stored values and how numbers are displayed in the Salesforce interface and reports.
Real-World Example
When a CRM manager at Summit Group needs to streamline operations, they turn to Decimal Places to centralize important business data in one place. With Decimal Places configured to match their workflow, the team can quickly find relevant information, track changes over time, and generate reports that drive strategic decisions.
Why Decimal Places Matters
Decimal Places is a configuration property on Number, Currency, and Percent custom fields that specifies how many digits are allowed after the decimal point. The valid range is 0 to 18, and the setting controls both storage precision and display formatting in the Salesforce UI and reports. The Length property of the field specifies how many digits are allowed before the decimal point, and Length plus Decimal Places together can total no more than 18 digits.
Picking the right Decimal Places matters for both data quality and user experience. A whole-number field like 'Number of Employees' should use 0 decimal places to prevent users from entering fractional values. A currency field for transaction amounts typically uses 2 decimal places to match standard accounting practice. Scientific or engineering fields may need more precision. Once a field is in use, changing Decimal Places can affect existing data: reducing the number truncates stored values, which is generally a one-way operation that should be tested in a sandbox first.
How Organizations Use Decimal Places
- •BrightEdge Solutions — Sets Decimal Places to 0 on integer fields like 'Number of Licenses' and 2 on currency fields, preventing entry errors and matching user expectations for each data type.
- •Coastal Health — Configured Decimal Places to 4 for laboratory measurement fields where additional precision is needed for clinical accuracy.
- •NovaScale — Tested Decimal Places changes in a sandbox before applying them in production after a near-miss where reducing decimals would have truncated existing financial data.
