Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,367,629
Community Members
 
Community Events
168
Community Groups

Calculating fields using Jira automation

Hello,

 

I am trying to use automation to calculate a field I have created (RICE).

The calculation is Reach x Impact x confidence/Effort.

I have tried using this logic 

{{#=}}{{issue.fields.reach}} * {{issue.fields.impact}} * {{issue.fields.confidence}} / {{issue.fields.effort}} {{/}}

I keep getting errors  saying I have an unknown operator * at the character position. Does anyone know if I am missing something?Capture.PNG

 

3 answers

1 accepted

0 votes
Answer accepted
John Funk Community Leader Aug 10, 2021

Hi Emily,

It looks like you are missing a value (field is probably empty) and it is not handling that. Seems to be the field called Impact. 

I would check the value of all of those fields for the issue it is running against so make sure none are empty.

I would also setup a default value for each field so that in the future you don't run into the same error. 

Thank you John, I think that has solved an issue , but I am now getting an error on missing parameters. Please could you advise?Capture.PNG

John Funk Community Leader Aug 10, 2021

I don't think it will make a difference, but you don't need the word "fields" in there. Just take it out. 

If no difference, can you share the entire rule? 

Hi John, 

 I noticed we had another custom field called 'Impact' which was not a numeric field and I must have selected the wrong one in my rule. Added the correct one and it's working now. Thank you for your help :) 

John Funk Community Leader Aug 11, 2021

Great! Glad you figured it out.  :-)

Hi All,

I have a similar problem with the same error, but the resolution eludes me.
It seems that I have multiple custom fields but I have no control what is being selected from the dropdown (when/where value change is monitored).

two questions came to my mind:
1 - what type the custom field has to be (I'm assuming number)

2 - is there a way to manage custom fields and remove the unused ones?

 

Screenshot 2022-09-29 at 19.14.02.pngScreenshot 2022-09-29 at 19.13.36.png

when I select the field, only one appears from these above

Hi Emily, 

 

I am looking to implement a similar automation, would you be able to share a screenshot of your flow?

 

Thanks

Hi Alex, 

I created the rule for RICE scoring using this method (I created 4 custom fields first) Hope this helps.

Rice 3.PNG

 

Rice 2.PNG

 

Rice Score = {{#=}}{{issue.reach}} * {{issue.impact}} * {{issue.confidence}}/{{issue.effort}}{{/}}

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events