Can I create a custom formula to replicate the impact score without normalisation?

Liz Collier-Harrison
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!
February 16, 2024

I'd like to replicate the formula powering the impact score without normalisation taking place. My impact score is configured like so:

 

Screenshot 2024-02-16 at 10.16.35.png

 

To replicate this I created the following custom formula:

({Annualised Benefit}*0.6 + {Impact (I)}*0.2 + {Confidence}*0.2) / ({Effort (E)}*0.2 + {Upfront Investment}*0.4 + {Annualised Recurring cost}*0.4)

 

This generates me a score without normalisation which is exactly what I'm looking for, however when I created an additional field using a weighted field applying that formula (100% positive input) to check the accuracy of my formula I get slightly different scores to the out of the box impact score.

Screenshot 2024-02-16 at 10.20.05.png

 

Please could someone advise me If i'm missing something very obvious with my formula? (or if the inbuilt impact score is doing something that can't be replicated)

 

Thanks!

1 answer

0 votes
Nick Haller
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 2, 2024

Hi @Liz Collier-Harrison ,

I believe this should be possible with a write-you-own custom formula

As you mentioned, weighted scores will use normalization to compare the formula's value to all other ideas, while write-your-own custom formulas simply calculate the value on a per-idea basis, and return the score not based on any other ideas.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events