1. Administrator's Guide
  2. Rule Functions
  3. SwitchSign

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 11-49 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