DJK(John) Robinson
djkr at msn.com
Tue Jan 24 19:20:17 CST 2006
No reason why they *should* be the same mathematically. The ratio of the sums is just not the same thing as the average of the ratios. Question is - what are you trying to achieve? Consider 1 2 0.5 999 1000 0.999 ---- ---- ----- 1000 1002 ??? if that helps. John -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: 25 January 2006 00:50 To: Access Developers discussion and problem solving Subject: [AccessD] bust out the math books can someone answer me this: C1 C2 C3 1566 1770 0.884746 5130 5340 0.960674 1320 1800 0.733333 6440 7280 0.884615 1770 1800 0.983333 16226 17990 0.901946 If I take C1 / C2 I get C3... there must be a mathimaticall reason as to why I can't just average column C3 to get the 90%, instead I end up with 88.93% any thoughts? -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com