Sum over sub-items don't work as expected In a Formula column using Jira Structure

Jose Vicente Sogorb
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 21, 2024

In Jira Structure plugin:

I am trying to sum up the total time employees have dedicated to each project category.
To do so, I have a board with the following generators some generators you can see in the image.

I have created a formula column for each project category to sum up the totals based on the project 
image.png
Where timeinprogress is a variable, and it works.

I have also selected the option "Sum over sub-items"

The problem is it is always summing 0 for groups or tasks with subtasks

image.png

 

What am I missing?

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
1 vote
Answer accepted
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 22, 2024

Hello @Jose Vicente Sogorb 

When you reference the Time in Status in the Formula, the 'Sum over sub-items' option is not being carried over from the column to the variable. You need to sum the values up in the formula like this:

sum{timeinprogress}

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)

Jose Vicente Sogorb
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 27, 2024

Works like a charm, thank you!

Like Stepan Kholodov _Tempo_ likes this
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events