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?
