How can we use "Effort" as a negative weight for impact scoring?

[Benedict Lubik]

Hey everyone,

we've been trying to implement a very basic, custom formula for impact scoring in our team. We are using three metrics that positively impact our score (Business value 1-5, Key Customers (weighted), Insights (amount)) and one metric that is supposed to negatively impact our score (Effort).

Is there anyway to map this without using a custom formula? It seems to us that if we only use one negative metric, it weighs 50% in our total score.

Best,

Benedict

[Tanguy Crusson · Accepted solution]

Hi @Benedict Lubik

you can either use a Weighted score formula with both positive and negative inputs,

or, if that's not working for you:

you'll soon (within a week?) be able to use negative numbers in the "positive inputs" section - we've seen some teams with more exotic needs where this would help.

[Tanguy Crusson]

The way it works with fields in the "negative inputs" section:

Normalize ( Normalize ( Positive1 ) * weightP1 +  ...  + Normalize ( PositiveX ) * weightPX)

/ 

Normalize ( Normalize ( Negative1 ) * weightN1 +  ...  + Normalize ( PositiveX ) * weightNX)

If you put everything in the positive inputs section and use a negative number in the positive input section, it will normalize by adding everything, including the negative number. 

Sorry, I couldn't find a way to explain it in plain English in a way that made sense 

[Benedict Lubik]

Hi @Tanguy Crusson 

thanks for getting back to me so quickly. I struggled with formulating my question as well so no worries, I understood your answer. We will just wait for you to release an update then!

BR

[Hannes Krug]

you'll soon (within a week?) be able to use negative numbers in the "positive inputs" section - we've seen some teams with more exotic needs where this would help

Upvote for that 

[Tanguy Crusson]

It's there already!