FX Currency values in reporting

Manage projects in multiple currencies with FX (Foreign Exchange) Currency. You can report on the projects in currency values entered by the user, a reference currency, or both.

Remarque :

You don't have to install a plugin to use FX Currency functionality. It's activated by default.

FX Currency functionality is described in detail in . In the context of reporting, it is important to aggregate on the reference currency which the other currencies are converted to.

Remarque :

When there are multiple currencies, calculations may not be possible. Change your aggregation source or filter conditions to show the report.

When you aggregate by Average or Sum on an FX currency field, you choose the Aggregation Source.

Use FX currency configuration

Calculates the values based on the FX Currency Configuration table. For more information, see Setting up and operating FX Currency fields.

As entered values

Calculate values based on currency values entered by the user.

Remarque :

If you select this option, you may experience situations where amounts entered in different currencies can't be properly aggregated. For example, if there are currency amounts in US Dollars, Yen, and Euros. It is only possible to aggregate values on one currency at a time. If you aggregate records in different currencies, this error displays: 'Cannot generate the report. There are mismatched currency codes.' See Mismatched currency example.

Reference values

Calculates the values based on the reference currency.

Report on FX currency fields

When you report on FX Currency fields, there are certain limitations that may generate errors. These errors are associated with aggregation.

Avant de commencer

Role required: itil, report_user, report_group, report_global, report_admin, or admin. To create a meaningful report, you must have the right to access the data you want to report on.

Procédure

1. Navigate to All > Reports > Create New.
2. On the Data tab, name the report, choose the source table with FX currency fields, and then click Next.
   The source must have FX Currency fields. See Setting up and operating FX Currency fields.
3. On the Type tab, choose the visualization type that you want to use.
   See Report types.
4. On the Configure tab, choose how you want to group, stack, and aggregate the report.
   It is only possible to aggregate values on one currency at a time. If you aggregate records in different currencies on an FX Currency field, this error displays: "Cannot generate the report. There are mismatched currency codes."

Mismatched currency example

When you report on FX Currency tables, some combinations of group and aggregation type are not possible to calculate. These combinations return the message 'Cannot generate the report. There are mismatched currency codes. Change your aggregation source or filter conditions.'

The source of this report has costs in euros, Japanese yen, and British pounds. This visualization aggregates costs by count distinct, meaning that each individual value gets its own segment.

When you try to aggregate costs in multiple currencies by sum or average, there are several possible outcomes.

Aggregation Source is Use FX Currency configuration

It is not possible to perform the calculation, because the currencies are mismatched.

Aggregation Source is As entered values

Usually the entered values are in multiple currencies as well and it is not possible to perform the calculation.

Aggregation Source is Reference values

In this case, the values are converted to the reference value before calculation and the report is generated. For more information, see Understanding FX Currency values in forms.