Example: Constant Currency Reporting with Virtual Versions

Basic Steps to Create Constant Currency Reports

Choose the sets of data.
Create Virtual Versions.
Build a matrix report, comparing the variance between the virtual version and the exchange rate version. See Create Basic Matrix Reports.

Constant Currency Walk-Through Sample

Create the Virtual Version

To report on variances with constant currency, always build the report with the new virtual version and the version you chose for the exchange rate of the new virtual version. The time spans you define in your report must relate to the time spans of the data sets. The table below explains how these rules work together:

Variances to Report	Virtual Version Base	Virtual Version Exchange Rate Version	Versions in Report	Time Span in Report
Current Budget to Current Year Actuals	Current Year Actuals	Current Budget	Virtual Version and Current Budget	Current Year
Current Year Actuals to Prior Year Actuals	Current Year Actuals	Prior Year Actuals (Offset Actuals 1 year backwards)	Virtual Version and Prior Year Actuals	Current and Prior Year

Go to
Modeling
>
Model Management
>
Versions
.
Click anywhere in the plan section of the list.
Click the
Create New Virtual Version
button from the toolbar.
Enter
Actuals at Budget Rates
in the
Name
field.
From the
Base Version
dropdown, select
Actuals
.
Click the
Edit
link to the right of the
Exchange
Rates
.
In the pop-up window, select the 2016 Budget (
Current Budget
) from the dropdown.
Because the base version is an actuals version, keep the
Enable Constant Currency Reporting
check box cleared.
For actuals versions, this option has no impact on the resulting values. When your base version is a plan version, select this option to apply the exchange rates of the plan version to the actuals overlay periods.
Click
Apply
and save.

You now have a virtual version of your actuals data with your budget's rates.

Build a Variance Report without Exchange Rate Fluctuations

To report the variance between the actuals data and the current budget without exchange rates fluctuations:

From the Reports Overview page, click
Add New
and select
Matrix
.
From the
Elements
list, click
Versions
,
and drag and drop the
Actuals at Budget Rates
virtual version into the column segment.
Drag and drop the 2016 Budget (
Current Budget
) version (the version you used for the exchange rate of the virtual version) in the same column to right.
Click
Back to Elements
and click
Time
. Expand until you find 2016 (the time period that corresponds to the base you selected for the virtual version). Keep 2016 collapsed and drag and drop it into the column segment, above your versions. You can also expand it to see quarterly or monthly variances, or you can drag it into the Filters segment.
Click
Back to Elements
and click
Calculations
. Drag and drop the
Difference
element to the left of the two versions in the column segment.
Right-click on the difference element in the report grid and select
Properties
.
Enter
True Variance
in the
Label
field and click the
Reverse Sign
checkbox.

Click the
Difference Options
tab.
In the
Subtract Version
section, choose the current budget from the
Version
dropdown. In the From
Version
section, choose
Actuals at Budget Rates
from the
Version
dropdown.
Click
Apply
.

Click
Back to Elements
and click
Accounts
.
Drag and drop
PL
Income
,
PL COGS
,
PL Expense
and
Net Income
into the row segment. Your report should look like this:

Save and run the report. The variance in the last column reports the difference without the effects of exchange rates.