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!

[Robert Wen_ReleaseTEAM_ · Accepted solution]

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_ReleaseTEAM_ 

[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_ReleaseTEAM_]

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

[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...