All eazyBI for Jira eazyBI for Confluence Private eazyBI

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.