(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