This function calculates the relative exchange rate between a parent and child, returning a value as a multiplier. The value is calculated based on the TriangulationCurrency parameter.
If the TriangulationCurrency parameter is a valid currency label, the cross rate is based on this currency.
If the TriangulationCurrency parameter is blank ( " " ), the function first searches for a valid direct rate, and if none is found, uses Triangulation against the application currency.
If no rate values are found, the function returns 1.
These tables show the methods of searching for the data and the order in which the search is made. The order is represented by a number in parentheses, for example (1). In each case, the search is made first in the child entity and, if no data is found, then from the “[None]” entity.
In the following table, either the currency of the child or of the parent is the same as the Triangulation currency, or if Triangulation is blank, the application currency.
Table 101. Rate Example — Triangulation Currency Same
Custom 1 dimension rates | |||
|---|---|---|---|
Child | Parent | ||
Custom 2 dimension rates | Child | (2) | |
Parent | (1) | ||
In the following table, Triangulation has been specified and is not the same as either the child or parent currencies.
Table 102. Rate Example — Triangulation Currency Different
Custom 1 dimension rates | ||||
|---|---|---|---|---|
Child | Parent | Triangulation | ||
Custom 2 dimension rates | Child | (2) | ||
Parent | ||||
Triangulation | (1) | |||
In the following table, Triangulation has not been specified and the application currency is different from both the child and parent currencies.