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

Problems with lookups and multiplying values

Izzy Clatworthy

Morning,

I'm trying to create a scoring system for our issues. This is done by the person filling out the form entering a priority and severity value from lowest to highest (with low, medium and high in the middle).

I have then got a look up table relating these to values 1-5

I am then creating smart variables to lookup the value in the table that is provided in the issue.

I then use these issues in an if else block,

If {{severityValue}}*{{priorityValue}} is less than 5 show low

If {{severityValue}}*{{priorityValue}} is greater than 12 or either value equals 5 show high

Else show medium.

I can not get this to work however. I think it is the multiplication part of this that has become my downfall, I've tried many many variants of it and can't seem to get it to work. It just automatically goes to medium every time unless either input is highest so equal to 5. This returns a high

Thank you in advance

Accepted answers

John Funk

Hi Izzy,

Can you share the actual rule that you have now, showing the details of the field for the calculation?

Also, try adding some log actions to that will show you the value after to select it to be sure it is returning the values you expect it to.

Izzy Clatworthy

Hello, following the suggestion to log the variables I've managed to work out it was the priority field giving us an Issue due to us using the Jira field Priority rather than a custom field.

We've managed to solve it and I've had a mini celebration.

Thanks for all the help.

Jira problem example 8.png

All comments

John Funk

Hi Izzy,

Can you share the actual rule that you have now, showing the details of the field for the calculation?

Also, try adding some log actions to that will show you the value after to select it to be sure it is returning the values you expect it to.

Izzy Clatworthy

Hi @John Funk

I'm currently using {{severityValue}} * {{priorityValue}} in the first value field on an if else block Jira problem example 1.png

Thank you I'll try adding some log actions

John Funk

You are not going to be able to put two values in the First Value field. You could create a variable using that calculation first, then use the variable name in the First Value field.

Izzy Clatworthy

Ok thank you, I have created a new variable to put the function in, however I can still not get it to work. If I use

{{severityValue}} * {{priorityValue}}

It just returns an error saying it is missing parameters

If I use

It just returns the else option of the if else block when it shouldn't.

@John Funk

Izzy Clatworthy

Hello, following the suggestion to log the variables I've managed to work out it was the priority field giving us an Issue due to us using the Jira field Priority rather than a custom field.

We've managed to solve it and I've had a mini celebration.

Thanks for all the help.

Jira problem example 8.png

John Funk

Great! Glad you got it working.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud