Skip to main content
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday company.

Currency Displayed in Reports

Question

How do I know what currency is showing in my report?

Answer

  1. When no level is included on the report, values will show in the Corporate Currency (currency assigned to the top level).
  2. When multiple levels with different currencies are placed on the report, values will show in the Corporate Currency.
  3. When child levels all in the same currency are placed on the report, values will show in those levels’ currency.
  4.  When parent levels are placed on the report that roll up child levels all in the same currency and the parent level is the same currency as well, values will show in those levels’ currency.
  5.  When parent levels are placed on the report that roll up child levels in different currencies or the parent level is a different currency, the child values will show in the Corporate Currency.

To display data in different currencies, you can include a currency element on the report and make it a parameter if needed.

Currency rates exist in the system based on the natural conversions in your level structure. The Currency Exchange Rates page will show available conversions (Modeling > Model Management > Exchange Rates).

For example:
  • If there is a child level in USD and a parent in CAD, for CAD|USD and USD/CAD. If there is a level in USD rolling up data from GBP levels, there will exist USD/GBP and GBP/USD rates.
  • If there is a level in USD rolling up data from GBP levels, there will exist USD/GBP and GBP/USD rates.
  • If there is no interaction between GBP and CAD in the system (meaning no child/parent relationships between the two), GBP/USD rates would not exist.
    • To add currency pairs that would not exist naturally in your level structure, you can go to Modeling > Model Management > Currencies > “Edit” next to a currency > and check the Create default reporting rates box.
  • Was this article helpful?