I would like to add the given criteria to the scorecard using this number field value.

testpinaack

 

Hi Team,

I have created a custom field of the 'number' custom field type. I would like to add the following criteria to the scorecard using this number field value.

Criterion                          Weight

value ≤ 33                         25%

33 < value ≤ 66                50%

66 < value ≤ 100              100%

Could you please confirm if it's possible or could you please provide input on how to implement the above criterion in the scorecard using an operator?

Thank you!

 

 

Nick Haller

Hi @testpinaack ,

Not entirely sure that is possible with a weighted score, especially since these types of formulas can only have a field entered once as an a positive/negative input, and doesn't have the option to account for IF/THEN clauses like you shared.

I also think you may run into problems with this since weight scores are normalized. What is normalization?

Normalization is an operation that takes all field values across all ideas in a project.

• 0 is taken as the minimal value. Alternatively, we take the lowest number if you are using negative numbers.

• 100 is the highest field value.

• All values are then plotted based on their relative value between the lowest and 100.

^ So as mentioned, this is factored among all ideas. Whatever the highest number-field is will be 100, while the lowest will be 0. The range will essentially be disregarded in some cases.

 

Instead you might find value in formatting the number field to the criteria you mentioned. Might look something like this: