SwitchSign

Determines if credits are switched to debits for the current Custom member or for a specified custom member. This function reverses the debit/credit sign using these rules:

ASSET to LIABILITY
LIABILITY to ASSET
EXPENSE to REVENUE
REVENUE to EXPENSE
BALANCE to FLOW
FLOW to BALANCE

This function can be used in these types of rules:

Calculation
Translation
Consolidation
Allocation

Syntax

HS.<Object>.SwitchSign("Member")
HS.<Object>.SwitchSign("")
HS.Custom(Dimension).SwitchSign(Member)

Note:

Use a blank string ("") to apply this function to the current member.

Table 82. Syntax for SwitchSign Function

Parameter	Description
<Object>	One of these object keywords: Custom1 Custom2 Custom3 Custom4 Custom
Member	Name of a valid Custom dimension member.

Return Value

A Boolean expression that is True if credits are switched to debits for the Custom member or False if credits and debits are not switched.

Example

In this example, if the credits and debits are switched, then statements between the If...Then and End If statements are executed:

If HS.Custom1.SwitchSign("") = TRUE Then
  ...
End If
If HS.Custom("Product").SwitchSign("P3000-Phones") = TRUE Then
...
End If