# Summing results on another level

**URL:** <https://community.eazybi.com/t/summing-results-on-another-level/81>\
**Category:** Questions & Answers\
**Tags:** mdx\
**Created:** [June 15, 2017, 9:51am UTC](https://community.eazybi.com/t/summing-results-on-another-level/81 "2017-06-15T09:51:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [June 19, 2017, 10:53am UTC](https://community.eazybi.com/t/summing-results-on-another-level/81/2 "2017-06-19T10:53:47Z")

</div>

Hi Jacques

DateDiffDays is the function for calculating the duration between Version Start date and Version End date. Then you would like to use this formula over the set of Fix versions for a particular project to count Product duration.

The formula below calculates the sum of version durations for all versions of the particular selected project “Product duration”:

```auto
Sum(
  Filter(
    Descendants([Fix Version].CurrentMember, [Fix Version].[Version]),
    [Measures].[Issues created] > 0
  ),
  DateDiffdays(
    [Measures].[Version start date],
    [Measures].[Version release date]
  )
)

```

Then you can use the calculated measure “Product duration” to calculate an average duration of all projects:

```auto
Cache(Avg(
  [Project].[Project].Members,
  [Measures].[Product duration]
))

```

Then you can use both measures on your report over projects.

 ![](https://community.eazybi.com/uploads/default/original/1X/afa5abd6e1599af9d132b1a248c9d9eccdff4569.png)

---

_[View the full topic](https://community.eazybi.com/t/summing-results-on-another-level/81)._