Share via

Using currency conversion functions to select exchange rate

  • Article

Planning Business Modeler includes a set of PerformancePoint Expression Language (PEL) currency conversion functions that enable you to use a variety of exchange rates in a Currency rule. These functions depend on an existing model-to-model association between a financial model and an Exchange Rate assumption model. Currency conversion functions may only be used in a Currency rule.

To change a particular exchange rate for a particular account type or flow type, substitute the currency conversion function that returns the exchange rate that you want to use.

For example, the following snippet from the Currency Rule template uses the AVE (PEL) function to convert Income Statement currency values.

SCOPE ([Account].ClassificationFilterInclude("Income statement", "Non financial"));
       () += AVE * CURRENTTUPLE;
END SCOPE;

The next example changes the rule segment so that the currency calculation uses HIST (PEL), the historical exchange rate.

SCOPE ([Account].ClassificationFilterInclude("Income statement", "Non financial"));
       () += HIST * CURRENTTUPLE;
END SCOPE;

Currency conversion functions

The following table describes the currency conversion functions that are included with Planning Business Modeler.

Function Description

AVE (PEL)

Returns the average exchange rate between the source currency and the currency to which it is being converted.

CLO (PEL)

Returns the closing exchange rate between the source currency and the currency to which it is being converted.

CLOAVE (PEL)

Returns the difference between the closing exchange rate and the average exchange rate. That is, it returns (closing rate - average rate).

CLOAVEPRIOR (PEL)

Returns the difference between the closing exchange rate and the prior average exchange rate. That is, it returns (closing rate - prior average rate).

HIST (PEL)

Returns the historical exchange rate between the source currency and the currency to which it is being converted.

OPE (PEL)

Returns the opening exchange rate between the source currency and destination currency.

PRIORAVE (PEL)

Returns the difference between the prior exchange rate and the average exchange rate, as applied to the data types of the specified model. That is, it returns (prior rate - average rate).

VAROPE (PEL)

Returns the difference between the opening exchange rate and the prior exchange rate, as it applies to the data types of the specified model.

See Also

Concepts

About the currency conversion template
Making a rule more general with #if - #else
Using SCOPE filters in consolidation and currency rules