Update parent field based on an operation of 2 fields from child

Question

I have the following structure

Story (Field: Progress)

- Subtask 1 (Field: SP, Field: Progress)

- Subtask 2 (Field: SP, Field: Progress)

I want to know if it is possible with Jira Automation to update Story Progress based on its subtask but doing an operation with both fields of the subtasks.. something like this:

Story.Progress = sum((subtask.sp/totalStoryPoints)*subtask.progress)

Hugo Loza · Answer

Thanks for the response:

- totalStoryPoints should be the sum of all the subtasks storypoints

then the formula (in pseudo code notation)

Story.Progress = sum((subtask.storypoints/totalStoryPoints)*subtask.progress)

As you can see what I'm trying to do is calculate the Progress of the Story based on the weighted progress of each subtask (weight represented by the subtask story point)

Pramodh M · Answer

Hi @Hugo Loza

Yes, it is possible with Automation.

If you clearly give the formula for the Progress field in Story Issue type that would be helpful.

Here you have given an example for two sub-tasks, we can consider this automation to work for any number of sub-tasks.

Let me know the exact formula. What is subtask.sp and totalStoryPoints represent?

Thanks,
Pramodh