I’m having a wood/trees moment…
I have a target of (say) 5,000, noting this may vary.
I also have 24 values between 0 and 10, let’s call them v1 to v10. These values are meant to be relative to each other.
I need to work out what percentage of the target each of the 24 values represents.
For example, if all the values were the same, then each would represent 4.1666…% of the total, no matter what the literal values were (meaning they could all be 1 or all be 7 or whatever).
I was thinking …
if I add all 24 values together, that would be the 100% value (HPV).
I then do this for each : percentage = (v / HPV) * 100
Then each row would have a value like this : absolute_value = (target / 100) * percentage
That seems to work in my head - does it make sense?