Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Summarize remaining in structure

Els Vercauteren
Contributor
August 1, 2023

In a structure i have a column which summarizes the remaining of the stories below.

I have an original estimate (goes also to remaining estimate) on feature level to indicate the budget we got for the feature.

On story level the team estimates in mandays

On feature level in summarize original estimate i see 2 sums.

One for sum of total (original estim of feature + all remaining of stories below) and a second sum in gray (in same field in gray with mention "this issue's own value in grey") for the value on the feature. (print in attach)

Question

- how can i only see the summarized value of the stories ? 

- in first line (red underlined) i want to see the 1week and 3 days (the 8 days sum from the stories only without the 1w on the feature level)

How can i get this ? 

 

Structure info

- feature with the below stories in the structure

- columns for sum timespent ; sum original estim ; sum remaining estimate

image.png

 

1 answer

0 votes
Stepan Kholodov _Tempo_
Community Champion
August 1, 2023

Hello @Els Vercauteren 

The Σ Original Estimate column indeed considers values of all issues, both parent issues and sub-issues. If you want to apply a different logic, you can do it with using the Formula column instead:

1. Add the Formula column to the structure.
2. Paste this formula in it: sum#strict{originalestimate}

As a result, the Original Estimate values will be aggregated but without including own value of the parent issue.

I hope this helps. If you need help with anything else, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov
Tempo

Els Vercauteren
Contributor
August 1, 2023

It works but in the next sumup on FIXversion i see the same popping up :-(

The sumup needs to be the sum of the below which was solved by your answer

Can we also solve that ?

image.png

Stepan Kholodov _Tempo_
Community Champion
August 1, 2023

You have the 'Sum over sub-items' option enabled in the Formula column's configuration. it is not needed - you're already summing up values using the sum{} function. You should get the right values once that option is disabled.

Best regards,
Stepan Kholodov
Tempo

Els Vercauteren
Contributor
August 1, 2023

I tried that already but than same as the other column (without formula) and as it is the same amount it is not ok as it should be less if summarizing the below no ? 

image.png

Stepan Kholodov _Tempo_
Community Champion
August 1, 2023

Unfortunately, your setup is not clear to me - there is still the Σ sum sign in the columns' titles which shouldn't be present in the Formula column(if the 'Sum over sub-items' option is disabled) and there is no hierarchy visible to evaluate what to expect here. Please submit a support request at our portal and we'll take a deeper look into this matter.

Best regards,
Stepan Kholodov
Tempo

Suggest an answer

Log in or Sign up to answer