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

Multi-Currency on Sheets

Describes how levels with different currencies display data on sheets.

For general information on sheets, see Using Sheets.

Levels in your model may have different currencies. Your admin can choose different currencies for each level. When you enter data, you enter data in the currency of the level. 

If you have access to multiple levels, check the currency at the bottom right corner of your screen:

Currency in Sheets.png

When levels are not in the rows, the sheet displays the currency of the level you select from the 1 filters of cube sheets, or the 2 drop-down in modeled or standard sheets. See Identify Sheets Types

Level Drop-downs1.png

When levels with different currencies are in the rows, the data displays in the currency of the top-most level.

In the example below, Total Company uses USD and the G&A level and sub-levels use GBP. The sheet, with levels down the rows, displays data in USD, the currency of the top-most level in this sheet. 

ViewbyLevel.png

The data you enter for any level on this sheet with levels in the rows is USD. When you change your view, and choose the G&A level, the sheet displays GBP again, converted from USD with the exchange rate chosen for the accounts.