I'm facing an issue with Jira automation rules where calculations involving custom numeric fields either return 0 or None, despite the fields being correctly populated with numbers. Here are the specifics:
- Environment: Jira Cloud
- Custom Fields:
Reach, Impact, Confidence, Effort (all numeric fields) - Problem:
- Simple math operations like
{{#=}} 2 * 3 {{/}} work correctly and return 6. - When trying to use custom fields in the formula, the result is either
0 or None. - Example formula:
{{#=}} {{issue.Reach | toNumber}} * {{issue.Impact | toNumber}} * {{issue.Confidence | toNumber}} / {{issue.Effort | toNumber}} {{/}}. - Fields are verified to be numeric and contain valid numbers (e.g., Reach = 3, Impact = 4, Confidence = 4, Effort = 2).
- The automation logs show an error: "Could not convert the field value to a number."
Steps Taken:
- Verified that all custom fields are set to numeric.
- Confirmed that fields are populated and accessible within the issue.
- Tested the formula with simpler arithmetic, which worked as expected.
- Attempted using
default() and toNumber() to handle empty or null values.
Request:
- Looking for guidance on why Jira might be returning
0 or None when using custom fields in math expressions. - Has anyone else experienced this issue, or is there a known workaround or fix?
Appreciate any help or insights!
