>I have a query which returns 4 percentages...
>
>
>59%
>52%
>100%
>84%
>
>
>Is the overall percentage 73.75%?
Yes, if the denominator of all 4 percentages is the same. If they are different you could get a different result e.g.
59% = 59 / 100 (denominator is 100)
52% = 26 / 50 (denominator is 50)
100% = 25 / 25 (denominator is 25)
84% = 21 / 25 (denominator is 25)
Overall percentage is:
( 59 + 26 + 25 + 21 ) / ( 100 + 50 + 25 + 25 ) = 0.655 ( 65.5 % )
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up