Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Structure Formula for Sprint and PI Percentage


We are using Jira Structure plugin to track our Projects. We have two fields "Program Increment (PI)" and "Sprint", all stories are linked up to PIs and Sprints. We want to have a report which can show the percentage of completed stories in each sprint and PI .

we are thinking to have a custom column which can show the percentage of sprint and PI fields. for that, I need to write a formula which I'm not able to.

Can someone help me with that formula??

And please let me know if there is any way to to get them as graphs.


2 answers

Hello everyone,

The described calculation should be possible now using the PARENT{SUM#children{ ... }} function. It was added in Structure 6.0, so please feel free to try the function in this version or in any later one.

Please feel free to reach out to us via if you need any help with the Formula column.

Best regards,
Stepan Kholodov
ALM Works

Hi Sai,

Thanks for posting. 

This is not yet possible in Structure. However, we are planning some major features for the Formula functionality, including aggregation over siblings. We don't have a timeline for delivery yet but I can notify you here once it's ready.

Please let me know if you have any additional questions.

Best Regards,


ALM Works 

Hi Vlad,

Could we get an ETA of when this feature will be available in Structure plugin.


Thanks and Regards

Shubham Singh

Hi Shubham,

There is still no definite ETA, as there is a lot of work there, but the feature is already under development.

Egor Tasa

ALM Works

Hi Egor,

Thank you for the information. We will inform the user with the same.



Shubham Singh

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

97 views 1 6
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you