Is division in custom formula fields broken in JPD?

Question

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!

Jet_m3qoex · Answer

Hi there!

This should work, can you please raise a support ticket (support.atlassian.com) for this and share screenshots or video recording of the issue?

Thank you!

Jet

Bill Sheboy · Answer

Hi @Calvin

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

Kind regards,
Bill

Jim Knepley - ReleaseTEAM · Answer

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