# How to show Original Estimate hours for closed sprint?

**URL:** <https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [April 26, 2022, 8:16am UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391 "2022-04-26T08:16:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yevhenii\_Pasichko](https://community.eazybi.com/user_avatar/community.eazybi.com/yevhenii_pasichko/32/6922_2.png) [@Yevhenii\_Pasichko](https://community.eazybi.com/u/Yevhenii_Pasichko)\
**Post date:** [April 26, 2022, 8:16am UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391/1 "2022-04-26T08:16:06Z")

</div>

Hi!

Could someone suggest how to solve the problem that Orignal Estimate field is empty in Closed Sprint?

I have already tried some tips how to solve it, but it doesn’t work  
[https://eazybi.com/accounts/1000/cubes/Issues/reports/395696-sprint-time-tracking-remaining-estimate-balance](https://eazybi.com/accounts/1000/cubes/Issues/reports/395696-sprint-time-tracking-remaining-estimate-balance)

> **[EazyBi - sprint original estimate at closing](https://community.atlassian.com/t5/Marketplace-Apps-Integrations/EazyBi-sprint-original-estimate-at-closing/qaq-p/1599590)**
>
> Hi! I have been challenged to create specific report for my team. We're using original estimated hours field in order to plan workload, so the value of this estimation has more less same meaning for us as story point. Now I want to catch this...

I will be grateful if someone could suggest any solutions.

Best!

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

---

<div class="post-metadata">

**Author:** ![Yevhenii\_Pasichko](https://community.eazybi.com/user_avatar/community.eazybi.com/yevhenii_pasichko/32/6922_2.png) [@Yevhenii\_Pasichko](https://community.eazybi.com/u/Yevhenii_Pasichko)\
**Post date:** [May 2, 2022, 7:40am UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391/2 "2022-05-02T07:40:02Z")

</div>

@EazyBILearner @easybi Maybe you can help with this issue?

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [May 2, 2022, 8:40am UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391/3 "2022-05-02T08:40:47Z")

</div>

Hi,

The Original estimated hours is a measure showing the “current status.” Once you use this measure with the Sprint dimension, the values show for those issues/sprints where the issue is currently. So, once the issue is moved from a closed sprint, the Original estimate does not show up.

A workaround is to use a custom measure like this:

```auto
NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
   0
))

```

This measure checks if the issue was in the sprint at closing and shows that estimate, regardless of to which sprint issue belongs currently.

Kindly,  
Janis, eazyBI support

---

<div class="post-metadata">

**Author:** ![Yevhenii\_Pasichko](https://community.eazybi.com/user_avatar/community.eazybi.com/yevhenii_pasichko/32/6922_2.png) [@Yevhenii\_Pasichko](https://community.eazybi.com/u/Yevhenii_Pasichko)\
**Post date:** [May 2, 2022, 10:28am UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391/4 "2022-05-02T10:28:37Z")

</div>

Hi @janis.plume!

Thanks for your help!

Everything is working fine! But unfortunately I missed that I need to show the Original Estimate Hours value for closed, active and future sprints in one line, I already tried to change your custom measure but it was not successful.

---

<div class="post-metadata">

**Author:** ![Yevhenii\_Pasichko](https://community.eazybi.com/user_avatar/community.eazybi.com/yevhenii_pasichko/32/6922_2.png) [@Yevhenii\_Pasichko](https://community.eazybi.com/u/Yevhenii_Pasichko)\
**Post date:** [May 10, 2022, 3:16pm UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391/5 "2022-05-10T15:16:45Z")

</div>

Hi [@eazyBI-Staff](https://community.eazybi.com/groups/eazybi-staff)

I have resolved the issue from the previous comment by changing the provided formula to

```auto
NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
  Original estimated hours
))

```

But, Now I noticed that it shows incorrect Total value in different reports,

 ![Easybi](https://community.eazybi.com/uploads/default/original/2X/4/409aa838cb0fda4a6d1cf3acd8934c82278165aa.png)

Do you have any suggestions on how to solve it?

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [May 12, 2022, 9:05am UTC](https://community.eazybi.com/t/how-to-show-original-estimate-hours-for-closed-sprint/9391/6 "2022-05-12T09:05:50Z")

</div>

@Yevhenii_Pasichko  
Try using the annotation sum in your formula:  
[https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Specialcommentswithannotations](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Specialcommentswithannotations)

Something like:

```auto
-- annotations.total=sum
NonZero(IIf(
  [Measures].[Sprint Issues at closing]>0,
  ([Measures].[Original estimated hours],
   [Sprint].CurrentHierarchy.DefaultMember),
  [Measures].[Original estimated hours]
))

```

That should force the sum function at the Total level of the report.

Martins / eazyBI