@ISACCTYPE

The @ISACCTYPE calculation function for Essbase tells whether the current member has a specified accounts tag.

This function returns TRUE if the current member has the associated accounts tag.

Syntax

@ISACCTYPE (tag)

Parameters

tag

Valid accounts tag defined in the current database. Any of these values may be used: First, Last, Average, Expense, and Twopass. To ensure that the tag is resolved as a string rather than a member name, enclose the tag in quotation marks.

Example

The following example is based on the Sample Basic database. For members with the Expense accounts tag, the formula uses the @ABS function to calculate Budget as the absolute value of Budget.

IF (@ISACCTYPE("Expense"))
   Budget = @ABS(Budget);
ENDIF;