(positive / (positive + negative)) * 100

-----Original Message-----
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Thursday, January 04, 2007 11:09 AM
To: CF-Talk
Subject: Easy one


My math skills seems to suck!!

I have a table where I am holding feedback left for sellers.

[feedback]

id (int)
positive (bit)
negative (bit)
rating (int) 1-5

I want to get the percentage of positive feedback against the negative. Say
a seller has received 456 positive ratings and 3 negative ratings. How would
I calculate the percentage of positive? I feel stupid even asking.



Doug B.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265627
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to