Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

Multi-Currency on Sheets

Describes how levels with different currencies display data on sheets.

Contains preview content for the upcoming 2019.3 release.

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 toolbar drop-down of modeled and standard sheets, or the 2 level filter of cube 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, the Headquarters level uses USD, the G&A level uses GBP, and the sales level uses CAD. The sheet, with levels down the rows, displays data in USD because it's 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.

  • Was this article helpful?