Automation for a special calculation

Thorsten Otto

Hi together, I^m new in Jira. And I want to do a special calculation.

My starting point is: I have 9 global evaluation fields, and I want to do a math operation for these 9 fields.

And now comes the tricky part. When I can only evaluate 4 of these 9 fields with 5 stars, the total should be 100% when the others are empty becouse I can`t evaluate them. Also when I have only 3 of the 9 or 7 of the 9 fields.

I have created a automation for this, but it will not work. 

I have my 9 evaluation field, and 1 field where the resulkt should be stored. This field is a Number field.

Now in the Audit-Log i see that the automation is working, but it could not write the output to the number field.

Automation:

Trigger: Value ChangeFields  > Evaluation field 1-9

Then: Edit Process fields 

SmartValuse:

{{#=}}
(
{{issue.customfield_20012|0}} +
{{issue.customfield_20013|0}} +
{{issue.customfield_20014|0}} +
{{issue.customfield_20015|0}} +
{{issue.customfield_20016|0}} +
{{issue.customfield_20017|0}} +
{{issue.customfield_20018|0}} +
{{issue.customfield_20019|0}} +
{{issue.customfield_20020|0}}
)
/
(
{{#if(issue.customfield_20012)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20013)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20014)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20015)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20016)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20017)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20018)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20019)}}1{{else}}0{{/}} +
{{#if(issue.customfield_20020)}}1{{else}}0{{/}}
)
{{/}}

 

Output should be witten to my Number Output field.

 

But my Jira every Time say:

The operation was successfully processed, but some of the specified fields are not available. 
Ignored fields:
Formula test thot (customfield_12044)

The field is there, i can manualy write numbers in it, but it still won`t work. Maybe im to silly to do that, or maybe it`s not possible to do that.

 

Christos Markoulatos -Relational-

Hey @Thorsten Otto  👋 Welcome to Jira

That audit message usually means the rule actor can’t edit that field for that issue, or the field isn’t available on the project’s Edit/Create screen or in the field’s context.

First do this checks:

• Make sure the rule actor (often “Automation for Jira”) has permission to edit the issue. If you use an Issue Security scheme, add the role atlassian-addons-project-access to the security level so the automation actor can see/edit the issue.
• Confirm the Number field you’re updating is on the Edit screen for that issue type and that the field’s context includes this project/issue type.

How to calculate “percentage of filled ratings”

From what you described, you want 100% whenever all filled ratings are 5 stars, regardless of how many are filled. That’s:

percentage = (sum of filled ratings) ÷ (count of filled ratings × 5) × 100

You can do this with a single smart value using math expressions ({{#=}}…{{/}}) and IF() to count only the filled ones. I’d also guard against divide‑by‑zero and round the result.

Replace the IDs with yours:

{{#=}} /* sum of ratings */ S = {{issue.customfield_20012.asNumber|0}} + {{issue.customfield_20013.asNumber|0}} + {{issue.customfield_20014.asNumber|0}} + {{issue.customfield_20015.asNumber|0}} + {{issue.customfield_20016.asNumber|0}} + {{issue.customfield_20017.asNumber|0}} + {{issue.customfield_20018.asNumber|0}} + {{issue.customfield_20019.asNumber|0}} + {{issue.customfield_20020.asNumber|0}}; /* count only the fields you actually evaluated (assuming stars are 1–5) */ C = IF({{issue.customfield_20012.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20013.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20014.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20015.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20016.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20017.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20018.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20019.asNumber|0}} > 0,1,0) + IF({{issue.customfield_20020.asNumber|0}} > 0,1,0); /* avoid divide-by-zero; scale to % and round */ IF(C = 0, 0, ROUND((S / (C * 5)) * 100, 0)) {{/}}

• Put that directly in the Edit issue → your Number field (not JSON).
• The asNumber|0 / |0 defaulting avoids errors when a field is empty.
• ROUND(..., 0) returns a whole number; change to 1 if you want one decimal place.

Trigger

Use “Field value changed” on your 9 rating fields, then Edit issue to set your output field with the expression above. That’s all.

If it still shows “ignored fields,” switch the rule actor to Automation for Jira (or yourself for a test) and re-run; if it works then, it’s a permissions/screen/context issue as noted.

Links that might help:

• Automation smart values – math expressions
• Examples using math expressions
• Fix “Unknown / Ignored fields” in automation
• Why fields get ignored during create/edit (Reporter example)
• Community tip: add atlassian-addons-project-access to Issue Security

Let me know if it worked