How to sum the original estimates in structure formula

shyam prasad August 25, 2021

Please help me on this.

 

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

1 answer

1 vote
Dionathan Lopes {ALM Works}
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
August 25, 2021

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 August 26, 2021

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. 

 

WhatsApp Image 2021-08-26 at 3.17.27 PM.jpeg 

Dionathan Lopes {ALM Works}
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
August 26, 2021

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 

Like Dave Rosenlund likes this
Jessica Wang May 17, 2024

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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 21, 2024

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)

Suggest an answer

Log in or Sign up to answer