Adding a Currency Conversion Row or Column

You can use the Calculation Editor to add a currency conversion row or column to your table.

Prerequisites

Select a table that's based on a model with currency conversion. To learn more about currency conversion, see Work with Currencies in a Classic Account Model or Work with Currencies in a Model with Measures.

Context

A currency conversion row or column allows you to see your values in different currencies and conversion rates.

There can be multiple conversion rates defined for each currency in the model’s currency table, and each currency can apply to different dates and different categories or versions.

If the currency conversion table for your model contains different conversion rates for the target currency, you can use the Date, Category, and Rate Version settings to control which rates are used in each conversion that you apply to a table.

Procedure

Select your table and in Builder, do one of the following:

Option	Description
Using a classic account model	Select Add Measures/Dimensions Cross Calculations. From the Cross Calculations dimension, choose (More) Add Calculation.
Using a model with measures	In a Measures dimension, select (More) Add Calculation.

The Calculation Editor appears.

From Type, select Currency Conversion.
Enter a name for the currency conversion.
For a model with measures, select the Source Measure with the values you want to convert.
Select the Target Currency that you want to convert to.
- Fixed: for a fixed target currency, select the desired country.
- Dynamic: for a dynamic target currency, select from a list of options.

Choose a Date.

Option	Description
Booking Date	Converts each value using the rate that applies to its own date.
Booking Date + 1	Apply a rate from a year, quarter, or month after the date for each value.
Booking Date - 1	Apply a rate from a year, quarter, or month before the date for each value.
Fixed Date	Apply the rates defined for that date to all values.

Choose a Category.

Option	Description
Dynamic	Uses the conversion rate defined for the category or version that correspond to each value in the model.
Actuals, Forecast, and so on	Applies the conversion rate defined for the selected category to all values.
Specific	Specify a Rate Version to use a conversion rate that's applied to specific versions.

Select OK.

A row or column is added. It shows the data values converted to the selected currency using the rates that you specified.

Note

If the maximum number of currency conversions for a table based on a classic account model has been exceeded, the Select Conversions menu appears. You can change the currency conversions that you want to display and then select OK.

If the currency conversion fails due to missing rates, a message is shown. Select Show more to show the rates that are missing by currency, category, rate type, and date.