Consolidated sum

Questions & Answers
1

Hello
Here are some explanations of my problem :

  • 7 milestones have a delivery date in january
  • 5 have a closure date in january
    But only 3, have a delivery date AND a closure date in january.
    How is it possible to have the 3 value in the first red cycle

Same thing for February :

  • 10 milestones have a delivery date in february
  • 8 have a closure date in february
    But only 6, have a delivery date AND a closure date in february.
    How is it possible to have the 6 value in the second red cycle

Thanks

Exemple
Exemple1280×720 94.6 KB

2

Hi,

This use case requires custom formula counting the aggregated number of issues where both measures are not empty. The formula is the following:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issues with free_field_date_02]>0
  AND
  [Measures].[Issues with closure date]>0
  )
))

Kindly,
Janis, eazyBI support