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

Automation to divide two custom numeric fields

Dionei Piazza

I need to get the result of divide two custom fields I created in Jira. I'm using automation with smart values. This is the syntax:

{{issue.customfield_10136}} / {{issue.customfield_10135}}

With this sintaxe I get this error message in the log:

========================================

Could not convert the field value to a number. Please ensure the value is a number, math expression or smart-value that can be converted into a number.

Desvio Estimativa: ( / 6.0)

No fields or field values to edit for issues (could be due to some field values not existing in a given project):

TES-46

========================================

Any help appreciated!

Accepted answers

Robert Wen_Cprime_

Do you have default values if the custom fields aren't set? e.g. issue.customfield_10136 should be 0 if not set and issue.customfield_10135 should be 1 if not set.

All comments

Fabian Lim

Hi @Dionei Piazza

Can you share what the type of customfields are the ones you are using for the calculations including the one with the formula?

Thanks,

Dionei Piazza

Hi @Fabian Lim

All Number fields.

Fabian Lim

Ok, never seen this error message, but can you confirm that the customfield does not have a context that blocks it from the TES project? Also make sure that the field is added to the screens of the issue type.

Dionei Piazza

The field appears in the screen.

If I set manual values in the automation it works. For example 4 / 2. In this case, it work fine!

But when I use the sentence {{issue.customfield_10136}} / {{issue.customfield_10135}}, it doesn't work.

I've try this way {{issue.customfield_10136.divide(issue.customfield_10135)}},

this way {{issue.customfield_10136.divide(issue.customfield_10135).floor}}, but it doesn't work...

Robert Wen_Cprime_

Do you have default values if the custom fields aren't set? e.g. issue.customfield_10136 should be 0 if not set and issue.customfield_10135 should be 1 if not set.

Dionei Piazza

Wow! It works now!

Thank you @Robert Wen_Cprime_

Natalia Matsyuk

A bit unrelated math function, but I found this video helpful: https://www.youtube.com/watch?v=Pi7_CInMTQc&ab_channel=ApetechTechTutorials

Robert Wen_Cprime_

Yeah, @Alex Ortiz is good with his videos from Apetech Tutorials.

Haley Soltau

I know this is old but as I was looking for this myself, I thought I would come back and share the answer.

This is what you need to put into your smart value calculation
{{#=}}{{issue.customfield_10136}} / {{issue.customfield_10135}}{{/}}

The begin and end symbols are what lest Jira know you actual want it to compute.

Everything can be found here...
https://confluence.atlassian.com/automation/jira-smart-values-math-expressions-993924866.html

Harsh_v2xlv7

Hi @Haley Soltau

II am using the same thing but unfortunately this does not work for me. I am using JIRA Server/DC. And I am performing the action on EDIT, i.e. after creation
Could you please help me out here. Thanks a lot.

I get the following error

Error rendering smart-values when executing this rule:

Missing parameter(s) for operator /: 25 /

Where 25 is the value for number field A

and I am dividing by 5 which is the value for number field B.

I am expecting a result of 5 here

Thanks in advance.

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

automation