All eazyBI for Jira eazyBI for Confluence Private eazyBI

IsEmpty

Determines if an expression evaluates to the empty cell value.

Syntax

 IsEmpty(Value_Expression)

Arguments

Value_Expression
MDX expression that typically returns a member or a tuple.

Examples

The example formula IsEmpty([Sprint].CurrentMember.get('Complete date')) will check if a sprint has a completion date representing the completed sprint.

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 filter to validate if the sprint is completed.