IsConsolidated

Determines if the current Account dimension member or a specified account member is a consolidated account. This function can be used in these types of rules:

• Calculation

• Translation

• Consolidation

• Allocation

Syntax

HS.Account.IsConsolidated("Account")

where Account is the name of a valid Account member.

HS.Account.IsConsolidated("")

Note:

You can use a blank string ("") to apply this function to the current member only if you are using it in the Sub Consolidate subroutine.

Return Value

A Boolean expression that is True if the account is consolidated into a parent account; False if the account is not consolidated into a parent account.

Example

In this example, if the Sales account is consolidated, then statements between the If...Then and End If statements are executed.

If HS.Account.IsConsolidated("Sales") = TRUE Then

  ...

End If