Skip to main content
Question

Scorecard 2.0: Weights don't appear to calculate decimal values

  • February 20, 2018
  • 9 replies
  • 107 views

darkknight
Forum|alt.badge.img+5
Before I begin, this could be resolved if we could just assign a weight to score Groups...

I have 8 measures that I pulled together under a Support score group.  The Support score should equate to 30% of the overall score.

If I have done my math correctly (which is always a valid question), this should come out to 3.75 % per measure.

When I enter 3.75 for each of those measures, the total only adds up to 24.



Of course if I change them to 4, it equates to 32 and if I drop them to 3 it equates to 24 also (the tool automatically does the latter f I submit and view the weight distribution again)

How am I supposed to split up measures across a group if it won't honor the decimals (that it permits me to enter)?

9 replies

aditya_marla
  • Helper ⭐️⭐️⭐️
  • February 21, 2018
Hi Jeff,

Thanks for pointing this out Jeff. In your case when you enter 3.75 (for 8 measures) the total should add to 30...we will fix this
For now, can you use integers in the weights? (Maybe use 375 instead of 3.75 for now?)

Regards

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • February 21, 2018
Hi Jeff, I've raised a ticket for this issue. Our support team will contact you on the issue. 

Thanks for sharing.

dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • March 5, 2018
Jeff, another way to use the weighting (and to get your creative juices flowing on this) is to use weights that add up to a total number greater than 100. Don't worry, the system will calculate the percentages correctly. 

So you could have metrics that have weights that add up to 200 or 1,000 or more (I think I've tested up to 50,000). 

A use case for the 50,000 would be a dimension that is normally not active (like CEO escalation score) but if it is active, it accounts for 99% of the score. You'd give this measure something like 30,000 in weight and every other dimension values that sum to 100 (or similar). Then normally this one heavy dimension is N/A and does not skew the scores, but if it has a value, it pulls everything to within 1 point of it's value. 

🙂

darkknight
Forum|alt.badge.img+5
  • Author
  • Expert ⭐️
  • March 5, 2018
Thanks Dan - that seems overly complex though.

I think it would be simpler/less complicated just to allow decimal points - I mean, if I can enter decimal points in the field (which I can) it should honor them right?  Based on Aditya's response sounds like that is how it should work.

PS I was never contacted by anyone in support as Sai said I should expect.  

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • March 7, 2018
@Jeff, Since support team able to reproduce the issue and accepted it as a bug,support team didn't contact you.

darkknight
Forum|alt.badge.img+5
  • Author
  • Expert ⭐️
  • May 4, 2018
@Sai - do you have an eta on when this would be fixed?  Thanks!

steve_davis
Forum|alt.badge.img+2
  • Gainsight Employee ⭐️⭐️
  • September 27, 2018
Jeff, this is currently being worked on by the team with an ETA of October release. 

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • October 10, 2018
@Steve is correct, you will get it in October release.

sai_ram
Forum|alt.badge.img+1
  • Expert ⭐️⭐️
  • October 16, 2018
Hi All, this is fixed and available in October release, Now you can now use decimal numbers up to two decimal points in weights.
Please refer the release notes for more information.

Thanks for posting!