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

Question

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 Answer

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 · Accepted Answer

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.