Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Help with fields dynamic calculation formula

Taras Korobko
April 30, 2023

Good Morning,

I'm quite newbie to jira but spend two weeks already on this task without success - Im trying to create the automation which will be counting dynamically the following fields:

Screenshot_324.png

in the following way - PM is adding Implementation Value and testing value basis, then during the process if tester found mistakes he can add value to the "Tester's value by mistakes" field and if he is updating value there it should substract that value from field "Ticket Implmenetation Value" and show the sum of all three fields in FINAL TICKET VALUE

The main issue that if after the first change - we want to adjust the tester's value by mistake field it substracts again the same value from the ticket implementation value while we want it to adjust difference only with the previous value. Also if we want to correct/remove value from tester's value by mistake field to make sure its added back to the ticket implementation value field and calculate properly Final Value.

Just to sum up the requirements of the automation:
- If value to the "Tester's Value by mistakes" added first time - it should substract from field "Ticket Implementation Value"

- If the value in field "Tester's value by mistakes" corrected to the lower amount then it was first time - it should add the difference to the field "Ticket Implementation Value"

- If the value in field "Tester's value by mistakes" corrected to the higher amount then it was first time - it should substract the difference from the field "Ticket Implementation Value".

-All the time field final amount should show the same sum of all three values.

Can someone please help with this? Maybe there any kind of workaround?
Thank you in advance.

1 answer

0 votes
miikhy
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 Champions.
June 13, 2018

Hi There,

To answer all of your questions:

  • Reporter will remain mandatory as it's a System field, you can remove it from the screen and it should be automatically filled (field configuration might also make it mandatory, check there!)
  • Summary is always mandatory but you can prefill it in the URL, like you did for issue type to avoid user from typing there!
  • The errors in your green box are Jira's information you can't really remove, it's an alternative to look for each error field when you have a very long form :)

Hope this helps!

Cheers

Suggest an answer

Log in or Sign up to answer