Hi
I'm grouping many CCD's into 4 electoral wards to work out the voters
in each ward which I have done with a simple sum aggregate, however I
would like to show
1. another derived column with the percentage of voters compared to all
voters and
2. another derived column with the percentage variation from the voters
compared to the mean in each group
however I am having a little trouble with the SQL syntax, any help would
be appreciated
eg below
Voters % Total % Difference
Bal 5000 27.0 8.1
East 4500 24.3 2.7
Middle 4300 23.3 7.0
West 4700 25.4 1.6
thanks
Steve
######################################################################
Attention:
This e-mail message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.
This e-mail has been scanned and cleared by MailMarshal
www.marshalsoftware.com
######################################################################
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
For more information please visit www.marshalsoftware.com
#####################################################################################
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
