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; } } }

Calculating fields using Jira automation

Emily Bleything

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?

Accepted answers

John Funk

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.

All comments

John Funk

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.

Emily Bleything

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

John Funk

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?

Emily Bleything

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

Alex Woodbridge_ixeldp

Hi Emily,

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

Thanks

Emily Bleything

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}}{{/}}

Peter Revay

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.png Screenshot 2022-09-29 at 19.13.36.png

Peter Revay

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

Vikas Gupta_s430cw

Hi @Emily Bleything Is there a way to do this based on the non numeric fields? Can I assign a dummy variable say impact = 2 if the value is low, 4 if high etc. and then calculate the Rice Score using the variable?

gaurav_jain

hey @Vikas Gupta @Emily Bleything ... were you able to find a way to achieve this ? Have a value for the dropdown list label ?

Russell Bailey

@Emily Bleything , thanks so much for this info. It helped me tremendously.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud