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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.