Is division in custom formula fields broken in JPD?

[Christian Becker]

Hi! In the process of setting up a simple RICE custom formula field exactly how provided in the field template I realised that the division calculation is not doing anything.

RICE Formula is set as: {Reach} * {Impact} * {Confidence} / {Effort}


What I found is that the division by Effort is just ignored and the numeric output of the field is just the result of {Reach} * {Impact} * {Confidence}

I tried multiple ways to fix it (removing spaces etc.) and even in the simplest calculation test division is ignored.

Example: {Reach} / 2 with {Reach}=5
Expected result: 2.5
Actual result: 5

Is anyone experiencing similar issues? Any idea how to fix that?

Thanks!

[Jim Knepley - ReleaseTEAM]

Hi @Christian Becker, welcome to the community.

As long as the various involved fields have numeric data types, I think you're doing that correctly. I found this Loom post that looks like it's working; he's not doing anything fancy:

https://www.loom.com/share/a09506455d6b4571a912567d5df4169b

[Calvin]

Heya, I wonder if you need to use the maths expression, something like:

{{#=}}{{Reach}} / {{Effort}}{{/}}

https://confluence.atlassian.com/automation/jira-smart-values-math-expressions-993924866.html

[Bill Sheboy]

Hi @Calvin 

This question is for the formula fields in Jira Product Discovery (JPD) and not for an automation rule.

Kind regards,
Bill