nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sum two values using JIRA Automation

visby8em

I want to sum values of two custom fields and save it in the third field.

When i write the rule like this

{ "fields": { "Total Effort": { "value": {{#=}}{{issue.customfield_10121}} + {{issue.customfield_10126}}{{/}} } } }

I get the error:

(Specify a number for the custom field (below 100,000,000,000,000) (customfield_10120))

if i write it like this:

{ "fields": { "customfield_10120": {{#=}}{{issue.customfield_10121}} + {{issue.customfield_10126}}{{/}} }

i get the error:

Error while parsing additional fields. Not valid JSON.

The custom fields are of datatype number

Accepted answers

Tomislav Tobijas

Hi @visby8em ,

Can you try using math expression directly in the field within Edit issue action (I'm assuming you're using this one?), and not necessarily advanced edit part of the action?

2025-01-17 09-01-47.png

For example, if the third field is also number type (where you're summing previous two values), automation could look something like in the picture above.

You could just use the expression

{{#=}}{{issue.customfield_10121}} + {{issue.customfield_10126}}{{/}}

and it should work.

If it doesn't, could you please provide screenshots of your rule together with audit log of error messages you receive?

Cheers,
Tobi

All comments

Tomislav Tobijas

Hi @visby8em ,

Can you try using math expression directly in the field within Edit issue action (I'm assuming you're using this one?), and not necessarily advanced edit part of the action?

2025-01-17 09-01-47.png

For example, if the third field is also number type (where you're summing previous two values), automation could look something like in the picture above.

You could just use the expression

{{#=}}{{issue.customfield_10121}} + {{issue.customfield_10126}}{{/}}

and it should work.

If it doesn't, could you please provide screenshots of your rule together with audit log of error messages you receive?

Cheers,
Tobi

visby8em

Thanks @Tomislav Tobijas

Putting the expression directly works fine.

Mohamed Eid

I tried to add days to a date and it didnt return an error but ofc the result isnt correct

-Expiration Date = Start Date: {{issue.description.substringAfter("This started at ").substringBefore(" ")}} + Remaining Days: {{issue.description.substringAfter("is expiring in ").substringBefore(" days")}}

which is

-Expiration Date = Start Date: 2025-01-18 + Remaining Days: 44.9999 -Expiration Date = Start Date: 2025-01-18 + Remaining Days: 44.9999

{{#=}}{{issue.description.substringAfter("This started at ").substringBefore(" ")}} + {{issue.description.substringAfter("is expiring in ").substringBefore(" days")}}{{/}}

it gives this

Log

2050.9999

Any ideas to fix this getting the right result for the expiry date ?

Tomislav Tobijas

Hi @Mohamed Eid

Would you mind sharing an example of a description here so I could test it out (can contain a dummy string; not necessarily a production one)? Also, please do share images of the rule together with the audit log (especially if you're using Log action to capture smart values and other outputs).