# Sprint Cycle calculated member

**URL:** <https://community.eazybi.com/t/sprint-cycle-calculated-member/11588>\
**Category:** Questions & Answers\
**Tags:** sprints, jira, calculatedmembers, hierarchy\
**Created:** [January 26, 2023, 5:53pm UTC](https://community.eazybi.com/t/sprint-cycle-calculated-member/11588 "2023-01-26T17:53:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jordan\_Wilkinson](https://community.eazybi.com/user_avatar/community.eazybi.com/jordan_wilkinson/32/6276_2.png) [@Jordan\_Wilkinson](https://community.eazybi.com/u/Jordan_Wilkinson)\
**Post date:** [January 26, 2023, 5:53pm UTC](https://community.eazybi.com/t/sprint-cycle-calculated-member/11588/1 "2023-01-26T17:53:00Z")

</div>

I’m attempting to aggregate sprints into PIs. I have started by using the additional import method to get sprint weekly cycles as instructed here:  
[Documentation](https://docs.eazybi.com/eazybi/learn-more/learn-eazybi-through-examples/sprint-reports-for-sprint-week-cycles-sprint-custom-hierarchies#Sprintreportsforsprintweekcycles(Sprintcustomhierarchies)-ImportSprintpropertyWeekcycle)

Now I am trying to aggregate members similarly to the tip provided in [this thread](https://community.eazybi.com/t/safe-similar-program-increment-time-hierarchy-member/4875/2)

I have tried two different formulas:

```auto
Aggregate({
   [Sprint.Week cycle].[22W49, Dec 05 2022],
   [Sprint.Week cycle].[22W51, Dec 19 2022]
})

```

and

```auto
Aggregate({
   [Sprint.Week cycle].[Week cycle].[22W49, Dec 05 2022],
   [Sprint.Week cycle].[Week cycle].[22W51, Dec 19 2022]
})

```

both result in the following error when selecting the calculated member:

> Failed to execute query. Error message:  
> Internal error: member [[Sprint.Week cycle].[PI 23-5] not found among its siblings.

What am I doing wrong? I assume it’s something small that I’ve missed.

 ![image](https://community.eazybi.com/uploads/default/original/2X/d/d476ad806c8567a8570846f4f2c04912546517bc.jpeg)

---

<div class="post-metadata">

**Author:** ![Jordan\_Wilkinson](https://community.eazybi.com/user_avatar/community.eazybi.com/jordan_wilkinson/32/6276_2.png) [@Jordan\_Wilkinson](https://community.eazybi.com/u/Jordan_Wilkinson)\
**Post date:** [January 30, 2023, 9:39pm UTC](https://community.eazybi.com/t/sprint-cycle-calculated-member/11588/2 "2023-01-30T21:39:11Z")

</div>

Well, it is indeed working! I came back the next day, and for some reason I am no longer getting the error.