How to sum the original estimates in structure formula

[shyam prasad]

Please help me on this.

I need to sum the original estimates of team, where i need to do this in formula in structure.

[Dionathan Lopes {ALM Works}]

Hello @shyam prasad 

Thank you for sharing your Structure Formulas question here on the Atlassian Community

You could try the below formula and see if it works:

SUM{if(OriginalEstimate != 'Empty'; OriginalEstimate)}

You would need to change the Format to Duration, by selecting it on the dropdown list right next to the "Options" field. Please refer to this article for more information - LINK  

Please let me know if it helps and don't hesitate to contact us if you need any further assistance.

Best Regards,
Dionathan Lopes
[ALM Works]

[shyam prasad]

Hi dionathan,

I do not see the sum values in my formula column. I want the sum of original estimates in formula. The sum needs to be in hours. 

 

[Dionathan Lopes {ALM Works}]

Hello @shyam prasad 

Thanks for letting me know.

In this case, you could try to add a column "Σ Original Estimate" and, for example, group issues by teams in your structure, and then the Original Estimate will be summed up for issues in each team-based group.

If you need further assistance with this, please reach out to us directly at support.almworks.com and we'll take a detailed look at your set-up.

Best Regards,
Dionathan L
www.almworks.com 

[Jessica Wang]

Hey thanks for the post!

Do you know what the formula is for a column indicating the remaining issues' original estimates, basically subtracting the done issues' estimates from the total estimates?

[Stepan Kholodov _Tempo_]

Hello @Jessica Wang 

You can do it with a formula like this:

sum{originalestimate} - sum{if status = "done": originalestimate}

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)