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

SwitchType

Determines if the account types are switched for the current Custom member or for a specified custom member. This function changes the account type for the Custom dimension member using these rules:

  • ASSET to EXPENSE

  • EXPENSE to ASSET

  • LIABILITY to REVENUE

  • REVENUE to LIABILITY

  • BALANCE to FLOW

  • FLOW to BALANCE

This function can be used in these types of rules:

  • Calculation

  • Translation

  • Consolidation

  • Allocation

Syntax

HS.<Object>.SwitchType("Member")
HS.<Object>.SwitchType("")

Note:

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

Table 11-50 Syntax for SwitchType 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 account types are switched for the Custom member or False if account types are not switched.

Example

In this example, if the account types are switched for the current Custom1 member, then statements between the If...Then and End If statements are executed:

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