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
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.