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.
-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 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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event