Structure formula aggregation with parameter

[shkim]

---

Hello  

I have structure like

• Story1, assignee A, 
• Story2, assignee B
•      Subtask1, assignee A
• ...

I want to sum duration of all stories or subtasks assigned each assignee.

Then I want to create new column like "duration of the story/ the sum".

To get the sum I tried

Parent#level=0 {

   Sum#leaves{ if assignee = this.assignee: enddate-startdate}

}

I expected this.assignee is fixed value of the current row, but it seem to change for every row.

Is there any way to pass variable like this.assignee to inner formula?

One more question is that  the sum calculation is done for every row. Is there any way to calculate it for each person without growing structure by person.

[David Niro]

Hello @shkim ,

Welcome to the Community!

For this, I would recommend contacting our support team directly via our customer portal, support.almworks.com.

We will need to review your hierarchy and goals in more detail.  

Best,
David