Script to sum two Number fields and display result in third field?

Question

This should be very similar for you advanced scripters:  I have two Number fields ("Field A", "Field B") that I want to sum in a "Total" field.  I have script runner.  Can someone post for me the entire script that I could use to make this work?  I'm a weak scripter and need the entire script, not just excerpts.  Thanks you so much to anyone who can help.

This is similar to the question posted here, but I need someone to post the complete working script for me, which doesn't seem to have occurred in this entry:  https://community.atlassian.com/t5/Adaptavist-questions/SUM-the-values-of-2-Number-Custom-Fields-in-a-3rd-Custom/qaq-p/1248782#U2122588

kdickason · Answer

You're incredible.  My favorite person in the world today!  I will get to work on this now.

PD Sheehan · Answer

Because of your response to #5, my recommendation is to use a behavior script.

This way, the Total field will be visible on create/edit screens, but in a read-only fashion and calculate in real time as you change either Field A or FieldB.

The one CON to this option is that Field A and Field B will no longer be editable in-line. When you click on the pencil icon on one of those fields, the full edit screen will pop up.

Here is the script you will need:

import com.onresolve.jira.groovy.user.FieldBehaviours
import groovy.transform.BaseScript

@BaseScript FieldBehaviours fieldBehaviours
def fieldA = getFieldByName('Field A')
def fieldB = getFieldByName('Field B')
def fieldTotal = getFieldByName('Total')

def valueA = (fieldA.value ?: 0) as Number
def valueB = (fieldB.value ?: 0) as Number

def totalValue = valueA + valueB

fieldTotal.setFormValue(totalValue)

Now, go to Scriptrunner Behaviours

* Create a new behaviour configuration.
* Add mapping for your project (and issue type if applicable).
* Edit the behaviour config and add your 3 fields.
* On the total field, toggle the "writable" option to "readonly"
* On each of the other fields, click "add server-side script" and paste the script above in BOTH fields. Adjust the scripts to match the actual field names.

Here is what it looks like in my environment (I used 3 arbitrary number fields for example)

kdickason · Answer

Hi there, Thank you for replying:

1. Yes

2. Yes

3. No

4. No preferably, but doesn't really matter.

5. Real time preferred.

6. Yes, that would be acceptable.

7. I need A and B to either default to 0 or be allowed to be empty.  In either case Total should total any field that has a value above 0.

Wow, this is why I reach out for help.    @PD Sheehan