Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Suggestions how to configure a JPD expression in a custom formula field to display 2 decimal places?

Michael Tucker
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 20, 2026

Our organization is new to Jira Product Discovery and we're using it as an intake form to help with ideation and prioritization. I have created several weighted fields whose values are 1, 3, and 5 with those respective weightings. I have successfully created a custom formula field expression that applies different weightings, but it's rounding only to the tenth decimal place and I need the hundreth decimal place (for instance, the formula is producing 1.9 when I need 1.87). That expression is: 

(({Revenue - EVA Impact}*0.4)/4)+(({Revenue - Contract Volume}*0.4)/4)+(({Revenue - Strategic Alignment}*0.4)/4)+(({Revenue - Time to Value}*0.4)/4)+(({Cost Savings - Expected Cost Reduction}*0.35)/3)+(({Cost Savings - Risk & Compliance Avoidance}*0.35)/3)+(({Cost Savings - Efficiency Gain}*0.35)/3)+(({Engineering - Effort Size}*0.25)/2)+(({Engineering - Enablement Value}*0.25)/2)

There are Revenue, Cost Savings, and Engineering categories whose weights are 40%, 35%, and 25% respectively. 

I have tried using Rovo to help and the suggestion is to implement ROUND(my_expression, 2)

I have tried repeatedly with different variations of that, but am always receiving a "Could not parse expression" error. 

Any guidance on how I can change that expression to get the hundreth decimal place? 

1 answer

1 accepted

3 votes
Answer accepted
Kamila Czubaj
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 21, 2026

Hey, 

We do not support now the two decimal use case. 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events