I want to write a formula in Structure using EXPR language to calculate Progress

[Timothy Boone]

Our project has a customed defined hierarchy of 

Initiatives to Capabilities to Epics to Stories

Story Progress is easy not done = 0%; status DONE = 100%

Epic Progress  = (Sum of Child Story Pts DONE) / (Sum of Child Story Pts)

Capability Progress = (Sum of [Child Epic Job Sizes * Child Epic Progress] / (Sum of Child Epic Job Sizes)

However I don't know how to set up a formula to do conditional weighted sums using the EXPR language for the Structure.

Can anyone point me to how this can be done, or a real reference document for this kind of detail for the EXPR language?

[David Niro · Accepted solution]

Hello @Timothy Boone ,

What does "Child Epic Job Sizes" represent?  The count of Stories in each Epic?

It may be best to reach out to our Support team directly via email support@almworks.com or customer portal support.almworks.com.

Best Regards,
David

[Timothy Boone]

Thanks for the link.  I will ask the question there.

[Timothy Boone · Accepted solution]

We are using the Job Size field in Epics to represent size of an Epic relative to other Epics. For the Epic Job size values, we use a modified Fibonacci sequence (1, 2, 3, 5, 8,13, 20, 40, 100) where an Epic with a bigger Job Size means bigger work scope as compared to an Epic with a smaller Job Size value.

In general, we want an Epic scoped such that one Agile Team can complete that work (potentially with some help from other Teams) within one 12 week Program Increment.  A Program Increment being divided into 6 two week sprints.