Using formula in Structure to calculate sum from fields in tickets

ryanzawada August 21, 2019

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!

1 answer

0 votes
Vlad Lessage
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 21, 2019

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events