Changing Decimal Places on a Field in Salesforce Reports

Xactly Reporting package does not allow the number of decimals to be changed from the standard. However, you can create a custom formula for a specific field on the object. This formula will allow you to look to the same field, but have additional decimal places:

To see how many decimal places are allowed on the field:

1. Go to SFDC > Create > Objects
2. Select the object
3. Scroll to the section "Custom Fields & Relationships" and select the field you would like to change.
   NOTE: If you are looking to change all fields, you will need to do this on an individual field level
4. Click "Edit" > under the section "Currency Options" and "Decimal Places" to change the number to the desired amount.
5. Save

To change the number of decimal places by creating a formula:

1. Go to the custom object
2. Click on the 'new' button on section: Custom fields and Relationships.
3. Choose Data Type "Formula" and press 'next'
4. Give it a label and then choose 'number' in the formula return type. Choose '2' under 'Options' drop-down menu. Then click 'next'.
5. Choose Simple Formula Tab.
6. In the text box, enter the XC field of the XC object in which we are interested by choosing from the drop-down menu in "Insert field ". Click 'next'.
7. Chose the level of field-level security for Profile.
8. Decide if you would like to add it to the page layout of that XC object by either clicking on the text box or not.
9. Then click on 'save'.

NOTE: This process requires creating a new formula field for every field they want to report on with two decimal places. They would also need to add the field to the Report Type.