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 rule isn't recognising custom field as numerical

Lucy Cookney

Can anybody help me?

I'm trying to set up an automation rule which divides one field by another and populates a third field with the result. It's failing, saying that the first field isn't numerical 'CoD - 10081'.

Accepted answers

Bill Sheboy

Hi @Lucy Cookney

To perform that math operation on your CoD (Cost of Delay) to determine WSJF (weighted shortest job first), you need to use math operators:

{{#=}}{{issue.customField_10081}} / {{issue.customField_10024}}{{/}}

{{issue.customField_10081.divide(issue.customField_10024)}}

Please look here for more information:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/

Best regards,
Bill

Lucy Cookney

Thank you everyone for the help. I have now amended my rule to the below. Feel free to suggest anything better but this appears to work 😁

All comments

Joshua Sneed Contegix

Hi Lucy,

What type of field is CoD? Cheers!

John Funk

Hi Lucy,

Can you share a screen shot of the list of custom fields where it shows the field type?

Also, can you show the error message in the audit log that you are receiving?

Do either of the fields contain a value of 0

Bill Sheboy

Hi @Lucy Cookney

To perform that math operation on your CoD (Cost of Delay) to determine WSJF (weighted shortest job first), you need to use math operators:

{{#=}}{{issue.customField_10081}} / {{issue.customField_10024}}{{/}}

{{issue.customField_10081.divide(issue.customField_10024)}}

Please look here for more information:

https://support.atlassian.com/jira-software-cloud/docs/smart-values-math-expressions/

Best regards,
Bill

Lucy Cookney

Hi @Bill Sheboy

Thanks for the reply.

The second option appears to be accepted...but it's not populating the WSJF field.

I have the success message:

But the field is blank:

Thanks

Lucy

Lucy Cookney

Hi @Joshua Sneed Contegix

It is a custom number field.

Thanks

Lucy

Lucy Cookney

Hi @John Funk

Number fields:

I was getting this error message:

However, I am now using the expression:

{{issue.customField_10081.divide(issue.customField_10024)}}

This is showing as successful but the WSFJ field isn't populating:

Thanks

Lucy

John Funk

Which field is 10081 and which field is 10024?

And can you share the rule that shows where you are updating the field with the formula?

Lucy Cookney

10081 is CoD and 10024 is Story Points

Screenshot 2021-07-07 141404.png

Lucy Cookney

Oh that's strange, I've switched the numbers around to:

It's populating the field but with the incorrect answer:

Screenshot 2021-07-07 143042.png

Bill Sheboy

Okay...connecting my questions together where I believe John was heading:

You are showing the field names on the issue view, and have you confirmed how those match to the custom field IDs you are using in the calculation?

Let's try this:

Using the Log Action, please write each of your calculation parameters to the log so you can compare what you believe is being used versus what is in the fields.
Using the instructions in this post, please use an example story to confirm the custom field ids (and smart values) match what you expect: https://support.atlassian.com/jira-software-cloud/docs/find-the-smart-value-for-a-field/
- basically you call the REST API with a browser, and get back the data for an issue...with the associated field names and data.

Thanks!

Lucy Cookney

Thank you everyone for the help. I have now amended my rule to the below. Feel free to suggest anything better but this appears to work 😁

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