Help with fields dynamic calculation formula
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:
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
1 accepted
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.