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.
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
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
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events