Open issues counts tickets with Derived status (and Derived it's a Done category status)

[walterdp]

Hi all:

We are using the Open Issues field to show the pending tickets. The problem is that the count includes some tickets in Derived status, which is (I hope) a Done category status. Here is the code for the field:

CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN
  Cache(
    NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
      Cache([Measures].[Issues created]
          - [Measures].[Issues resolved])
    ))
    + [Measures].[Issues created]
    - [Measures].[Issues resolved]
  )
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN NonZero([Measures].[Issues due])
ELSE
  -- optimized formula for drill through Issue
  NonZero(IIF(
      DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Created at'),
        [Time].CurrentHierarchyMember) AND
      NOT DateBeforePeriodEnd(
        [Issue].CurrentMember.get('Resolved at'),
        [Time].CurrentHierarchyMember),
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created]),
    0
  ))
END

I know I can filter Derived out but that also will filter it out from the Restored issues (the Derived status is used when a Problem ticket is generated using the incident ticket. The incident changes to Derived as a Done status)

Thanks

W.

[walterdp]

Hello?

Anybody?

Please!!!