ISEMPTY
This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
This function is used to return whether the evaluated expression is the empty cell value.
Syntax:
IsEmpty(Value_Expression)
Return Type:
LOGICAL
Parameters:
Parameter | Description |
|---|---|
Value_Expression | It is a valid MDX expression, typically returns the cell coordinates of a member or a tuple. |
Example:
WITH MEMBER MEASURES.ISEMPTYDEMO AS
IsEmpty([Measures].[Internet Sales Amount])
SELECT {[Measures].[Internet Sales Amount],MEASURES.ISEMPTYDEMO} ON 0,
[Date].[Fiscal].MEMBERS ON 1
FROM [AdventureWorksMF]