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

[Hugo Loza]

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)

[Pramodh M]

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

[Hugo Loza]

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)