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

Liz Collier-Harrison

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

 

 

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.

 

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!

Nick Haller

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.