Hi all, you may have read my post regarding bars and values and stuff, well I've got that bit figured out now but as my programme is expanding, so is the number of records being parsed into it!
I'm working out a percentage of 2 groups of people:
Number of people from the UK
Number of people from outside of the UK
etc...
Once the number has been calulated I print a percentage of that value compaired to the other value in the window...
EG-1
1 person from the UK -so the value of this is now 1
0 people from outside the UK -so the value of this is still null (0)
Now I'm working out the percentage as follows: (100 being 100%)
100 / [sum of the values of UK and outside UK] * [the value of UK]
So:
100 / [1]*[1] = 100%
I'm having a problem when the UK or outside the UK value goes above 100 as the percentage for both values drops to 0%... How can this be resolved without the original percentage going above 100?
Thanks for reading, I look forward to reading your suggestions!!
Rob