---
schema_version: "1"
id: 4d859528a40520f5de9d66878ecbe9092d59f34312ddfc0c6bb9b4dc4045c068
title: Show Currency Codes in a Report in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_report_currency.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_report_currency.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3c2bc15f049241d07bc9d7d1899011c8f8331b3e086f1d671fd3d4196f3bb590
description: When you add a currency column to a report in Salesforce Spiff, by default the report doesn’t show the currency code. You can add the currency code for the Commission Amount column in statement reports and obligation reports.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Show Currency Codes in a Report in Salesforce Spiff

When you add a currency column to a report in Salesforce Spiff, by default the report doesn’t show the currency code. You can add the currency code for the Commission Amount column in statement reports and obligation reports.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d56973e76">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d56973e76 ">To edit a report:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d56973e76 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with this permission turned on.</p>
              <p style="margin-bottom:0;">Custom Reports: Edit</p>
            </td>

          </tr>
        </tbody>
      </table>

If a field has the Currency data type, either by syncing a currency data from an external data source or by specifying the data type in Designer, the currency code appears automatically when you export the report.

A statement report and an obligation report both include a Commission Amount column by default. For statement reports, this column represents the total commission amount for the statement‌. For obligation reports, this column represents the commission amount that’s calculated line-by-line or calculated for a lump-sum rule. For these reports, manually add the currency code for the Commission Amount.

1. In the report, click the Edit Columns icon.
2. Search for Currency Code, and then add the column to the report by clicking the **+** icon.
3. Click **Apply**.
4. Click **Run & Save**.

The column appears in the report and shows each amount's currency code.