Need help with Structure formula.

Question

Hello Community,

I am new to structure and need you help with a formula.

We have a demand to display number of completed stories before due date in a quarter by total number of stories due in that quarter under an epic.

Something like 23/40 - where 23 are completed before due date and 40 are the total number of stories due in that quarter.

Any help would be appreciated.

Best Regards,

Salvinder

Valerie Knapp_dpp5c6 · Accepted Answer

Hi @Sal , thanks for your question.

Have you tried anything yet that you can share so we can help you?

The Structure documentation has some good examples to help you get started if you haven't already looked here - Creating a Formula (almworks.com)

Please share your work so far and we can try to assist you to get it up and running correctly.

Cheers

Sal_5pm3j4 · Accepted Answer

Hi @Valerie Knapp Thank you for your help! I had discussion with ALM Works and they helped me with the code and after some little modifications I was able to get desired results. If issuetype = "Epic": (with x= IF issuetype = "Epic": SUM#children{IF issuetype = "user story" and status = "done" and duedate>=date("04/01/2023") and duedate<=date("06/30/2023"): 1 }: with y= IF issuetype = "Epic": SUM#children{IF issuetype = "user story" and duedate>=date("04/01/2023") and duedate<=date("06/30/2023"): 1 }: with z=concat(x, "/", y): if not defined(x) and defined(y): concat("0"; "/"; y) else if defined(x) and not defined(y): concat(x; "/"; "0") else if not defined(x) or not defined(y): concat("0"; "/"; "0") else z )