Formula returns empty set

Hello,

trying to build up a report that shows issues due that are already overdue. The report rows contain two customfields: FixVersion and Components (both are imported as Javascript customfield to satisfy requirements established by other teams and so far works fine). However the following formula returns empty set:

settostr(
Filter(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues Due] > 0),
Not isempty([Issue].CurrentMember.Get(‘due date’))
AND
DateDiffDays([Issue].CurrentMember.Get(‘due date’), Now()) > 0
))

Does anyone have ideas, why?

Hi,

I noticed a syntax mistake in your code (Due date property is in the sentence case and there is no need for two filters.
Please try the following code instead:

Settostr(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues Due] > 0
    AND
    Not isempty([Issue].CurrentMember.Get('Due date'))
    AND
    DateDiffDays(
      [Issue].CurrentMember.Get('Due date'), 
      Now()
    ) > 0
  )
)

Best regards,
Martins / eazyBI team