IsCalculated

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

• Calculation

• Translation

• Consolidation

• Allocation

Syntax

HS.Account.IsCalculated("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 a calculated account; False if the account is not a calculated account.

Example

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

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

  ...

End If