[SalesForce] How to remove the Decimal from a Currency Field

I want to get my custom currency field to show no decimal places, but when I update the decimal number in the customization page to zero, the field still shows 2 decimal places for the currency field on the page layout.

I have updated the decimal # to 0

However it is still showing 2 decimals

How can I fix this?

Best Answer

I would surmise you are using Advanced Multi-Currency in your org

There are two parts in play here

The decimal precision of the field itself (in your case 0) - this controls rounding done by SFDC when the currency is entered by the UI. See here for more details
The precision for display of the currency in the Setup | Company |Manage Currencies - most likely 2 for USD in your org

If you really want to eliminate the display of the trailing decimals for this specific field you have some options

Use a field of type Number and display the currency code separately. If this is an Opportunity, Quote, or Forecast, you will lose the advantages of dated exchange rates though
Convert your page to a VF page with apex:detail and then use jQuery to suppress the trailing zeroes. Inline edit preserved
Convert your page to a VF page and use a custom component for each currency outputField that suppresses trailing decimals based on some attribute passed tot he component. You will lose inline edit for the currency fields however

Related Solutions

[SalesForce] Controlling the data type of a custom field

The length and decimal places are only enforced when editing data via the standard web UI. Apex and API methods can actually save records with decimal places. This is true for standard and custom fields. To restrict the values to an integer, you'd have to put a validation rule in place or add a trigger to the object to do the validation.

EDIT: In the past I have seen numbers get inserted that don't match the field definition. I just tested using Apex, Workbench and Jitterbit to insert records and they all were rounded when viewing them in the web ui. I then added a trigger to capture the values before and after insert. The values have the decimals. Finally I inserted a record with decimals and then queried it using Apex and SOQL. The value is stored with the decimal! So, it looks like Salesforce has changed the display to match the definition, but they are stored in the database as inserted.

[SalesForce] How to display Currency field with all the decimal places without rounding it

Take a look at the docs on apex:outputText. You can use the Java MessageFormat format strings.

For example, the following will display US currency with six decimal places, formatted with comma separators, up to 999 trillion dollars and will always show six digits to the right of the decimal place due to the zeroes. This is Visualforce, though.

<apex:outputText value="{0, number, $###,###,###,###,##0.000000}">
    <apex:param value="{!myObject.My_Value__c}"/>
</apex:outputText>

Best Answer

Related Solutions

[SalesForce] Controlling the data type of a custom field

[SalesForce] How to display Currency field with all the decimal places without rounding it

Related Topic