Returns TRUE if the current member of the specified dimension is in the specified level.
Syntax
@ISLEV (dimName, levName | levNum)
Parameter | Description |
---|---|
dimName | Name of a dimension. |
levName | levNum | A level name or an integer value that defines the number of a level. A value of 0 or a negative integer defines a level number. |
Example
In the Sample Basic database:
@ISLEV(Market,0)
Returns TRUE if the current member of Market is New York, California, Texas, or Illinois.
@ISLEV(Year,1)
Returns FALSE if the current member of Year is Jan, Feb, or Mar.
See Also