Using formula in Structure to calculate sum from fields in tickets

Question

Hi Atlassian Community, was wondering if i could get some help with a formula.

Basically I would like to know how to add to fields together and then be able to multiply these numbers together. This information will be extracted from tickets within the structure from a project.

For example,

-Field 1 (i) = 4

-Field 2 (P)= 2

-Field 3 (O)= 2

-The formula adds P+i together to get the sum, then the formula multiplies (i) with the sum from (P+i), multiplied by (O) - (i x (P+i) x O).

Any help would be greatly appreciated.

Thanks!

Vlad[ALM Works] · Answer

Hi there!

Thanks for posting.

Just to make sure I understand the final number you're looking for, is it the following operation that you want?

Formula = (P+i) * (i) * ((O)-(i *(P+i) *O))

Please let me know if that is the case so I can help you with the Formula syntax.

I look forward to assisting you.

Best Regards,

Vlad