When we want to plan using different currencies, we need to ensure that our models are saved with currency conversion enabled.
For this example, we are working with a model that has the default currency set to USD.
and the maximum number of currency conversions that can be displayed in a single table set to the default value of 4.
Note that in the model’s Organization dimension, all of the regions also have USD as the local currency, apart from Overseas; its sub regions, EMEA and Asia Pacific, use the Euro and the Yuan respectively.
Now we will open a story based on our model.
To work with additional currencies, we will add the Calculations dimension to the table.
Note that all values currently display in the model’s default currency of USD.
By default, a filter is applied to the table to show only the default currency.
We will modify the filter so we can also see the local currencies.
Note that each account now has a row for local currency, but the cells do not display any values.
This is because there are multiple local currencies in the model, so it is not possible to aggregate the values.
We will expand the Region dimension for the Operating Expenses account.
Note that at the East US and West US levels, we can now see local currency values, but we still cannot see a value for Overseas.
This is because Overseas contains regions with different local currencies.
If desired, we can add other currency conversions to the table.
To do this, we need to add calculations.
We need to specify Currency Conversion as the calculation type.
Next, we will enter a name for the conversion, and we will set the currency to Euro.
Note that the list includes only those currencies for which there are entries in the model’s currency conversion table.
Next, we need to specify a date.
We can choose a fixed date, or choose the Dynamic option to use the rates that are valid for the time periods shown in the table.
Finally, we need to choose the category of the conversion rate we want to use.
We can select the default category of Dynamic to use the rates for each planning category as specified in the conversion table.
Alternatively, we can choose one of the standard categories of Actuals, Budget, Planning, Forecast, and Rolling forecast, to apply the rates specified for that category to all categories in our table.
We can choose the Specific option if our conversion table contains rates assigned to the Specific category, which also have named Rate Versions that we can select in the Rate Version menu.
For this example, we will choose the Dynamic option.
Note that if we were to choose currency conversion settings for which there are not corresponding rates available in the conversion table for our model, we would receive an error message specifying the missing rates, enabling us to update the conversion table to add them.
A line for Euros has been added for each member of the Account dimension.
We can add more currency conversions if we choose using the same process.
Note that once we have exceeded the maximum number of conversions set in our model, which in this case is 4, a Select Conversion option becomes available for the Calculations dimension.
Here we can choose which of the available conversions we want to display in the table.
The list of currencies displayed has updated.
Note that when we add multiple currencies to tables, the conversions do not display for private versions, only for public ones.
Also note that we can perform planning tasks on just one currency at a time.
For example, when we modify a value in Yuan… the values no longer display for any of the other currencies, including the default currency, because the version we are working with is now private and supports only a single currency.
To see the values and perform planning tasks using a different currency, we must first publish the changes to our version to make it public.
All of the currency conversions once again display.
Thanks for watching!.