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 first example formula IsEmpty([Sprint].CurrentMember.get('Complete date')) will check if a sprint has a completion date representing the completed sprint and return true if Complete date is missing.

The next example formula Not IsEmpty([Sprint].CurrentMember.get('Complete date')) will return true if the Complete date is entered.

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.