ABSExp

Executes a calculation expression and stores the result as an absolute value. This function is the same as the Exp function except that it stores the resulting value as an absolute value. This function can be used in these types of rules:

• Calculation

• Translation

• Allocation

Syntax

HS.ABSExp "DestPOV = Expression"

Table 11-2 Syntax for ABSExp Function

Parameter	Description
DestPOV	A destination point of view that identifies where to put the data You must specify an Account member, and you can optionally specify ICP and Custom members. Note these usage rules: If you do not specify an ICP member, the default is [ICP None]. To avoid populating the database with unwanted values, rules should be as explicit as possible in terms of defining where data should reside. A good practice is to include clearly defined Custom dimension intersections for the Account dimension. Such clearly defined intersections utilize Oracle Hyperion Financial Management validation checks to avoid writing data to invalid intersections. See Dimension Intersection Considerations.
Expression	A calculation expression

Return Value

None.

Example

This example sets the amount in the StateTax account. The example calculates the absolute amount by multiplying the amount in the Sales account for 2014 by the rate in the StateRate account for 2014.

HS.ABSExp "A#StateTax = A#Sales.Y#2014 * A#StateRate.Y#2014"