Follow
Creating Financial Data Reports with Unique Exchange Rates

If multiple exchange rates have been configured in Workfront, you can set financial values in reports to display in a currency other than the default currency. 

Before you can view alternate currencies as described in this section, the system administrator must first enable and configure multiple currencies, as described in "Setting Up Exchange Rates."

For information about how to change the default currency for a given project, see "Changing the Default Currency for a Project."

If there are projects with a single currency in the report, the sums in groupings are also displayed in system default currency.

Applying Financial Values to a Report

To convert financial values between currency when working with reports:

  1. Navigate to the report where you want to convert financial values to a different currency.
  2. Click the View drop-down list, click Change Currency, then select the currency that you want to use when viewing the financial values.
    Using this option allows you to quickly convert financial values in a report between rate values. 

Displaying the Default Currency Across Multiple Projects with Different Currencies

 

When you customize the currency at the project level and you want to display information from all the projects in the same report, the following scenarios exist: 

  • If you create a report that brings financial information from two or more projects that have different currencies applied, by default the grouping summary reflects the the system's default currency as selected by the system administrator.
  • If you create a report from two or more projects that have the same currency, but they differ from that of the system's default currency, then the sums in the groupings are displayed using the system default currency. 

To display two projects with custom currencies in a report: 

  1. Create two projects with different currencies applied.
  2. Log hours on both projects.
    For more information about logging time, see "Recording Time."
  3. Navigate to the Reporting area, and select the Reports tab.
  4. Click New Report, then Project Report.
  5. In the Columns (View) tab, add an Actual Cost column and summarize it by SUM.
    For information on how to create a column, see "Creating and Customizing Views."
  6. In the Groupings tab, apply a Planned Completion Date grouping.
    For information on how to create a grouping, see "Creating and Customizing Groupings." 
  7. In the Filters tab, add a filter for Project Name and select the two projects with the different currencies.
    For information on how to create a filter, see "Creating and Customizing Filters." 
  8. Click Save + Close.
    The total of the Actual Cost is displayed in the Grouping using the system default currency, regardless of the currency of the projects in the report.
    If the two projects have different currencies from one another, the system default currency also displays in the Grouping of the report.
    multiple_currency_projects.png

Displaying the Project Currency in a Report at the Project Level

If a grouping is applied on a task or hour list within a project, the sums in the grouping are displayed in the project's currency.

  1. Create a project with a custom currency, different than the system default currency.
  2. Navigate to the project and ensure that it includes hours that have been logged for tasks.
    For more information about logging time, see "Recording Time."
    NOTE The tasks should be assigned to users or job roles with Rate per Hour cost rates.
  3. Select the Tasks tab.
  4. Expand the View drop-down menu and select New View.
  5. Add Actual Cost in the new View as a new column, and summarize it by SUM.
  6. Expand the Grouping drop-down menu and select New Grouping.
  7. Add Actual Completion Date in the new grouping as a new field.. The Actual Cost column summarizes in the new Grouping and displays the total in the currency of the project. 

Editing Reports with Unique Currencies

The financial fields in a report are not editable until you change the report setting to show Project's original currency.

To in-line edit a financial fields in a report:

  1. Navigate to a report.
  2. Click Report Actions.
  3. Click Edit.
  4. Click Report Settings.
  5. Select Project's Original Currency from the Default Currency drop-down.
  6. Click Done.

 

This article last updated on 2018-03-07 16:02:52 UTC