Trans

Translates a currency using the year-to-date method. This function can be used in Translation rules.

Syntax

HS.Trans("DestPOV","SourcePOV","Rate1","Rate2")

Table 11-51 Syntax for Trans Function

Parameter	Description
DestPOV	The destination point of view. The destination can be a combination of Account, Custom1...4, and ICP members. For each unspecified dimension, the system writes to all valid members of the dimension. For each specified dimension, the system writes into the specified member only.
SourcePOV	The source point of view. The source can be a combination of dimensions. If the Account, Custom1...4, and ICP dimensions are unspecified, the system uses the same member as the Destination member. If the Scenario, Year, Period, and Entity dimensions are not specified, the system uses the current members. If the Value dimension is not specified, the system uses the <EntityCurrTotal> member. If the source point of view is blank, the system uses the destination point of view as the source point of view.
Rate1-2	The exchange rate. The rate can be a constant, an exchange rate account, or a specific cell. Rate accounts are input for entity and for [None] entity. For information about the default translation process, see Default Translation.

Return Value

None.

Example

This example uses the rate in the Rate1 account to translate the Sales account using the year to date method:

HS.Trans("A#Sales", "A#LastYearSales", "A#Rate1", "")