IsEmpty
Determines if an expression evaluates to an empty cell value. Returns true
if no value is present, otherwise returns false
.
Syntax
IsEmpty(Value_Expression)
Arguments
Value_Expression | MDX expression that typically returns a member or a tuple. |
---|
Examples
The first example formula will check if a sprint has a completion date representing the completed sprint and return true
if the Complete date is missing.
IsEmpty([Sprint].CurrentMember.Get('Complete date'))
The following example formula will return true
if the Complete date is entered.
NOT IsEmpty([Sprint].CurrentMember.Get('Complete date'))
The sample report Sprint velocity chart in our demo account uses the calculated member All Closed Sprints in Sprint dimension to show only completed sprints in the report. The default calculated member All closed sprints uses the formula as one of the filters to validate if the sprint is completed.