also, shouldn't those 2 tables be joined together some how?
On Wed, Mar 9, 2011 at 8:00 PM, Torrent Girl <[email protected]> wrote: > > Hi All > > I have the following function that I am TRYING to get the average of a sum > of 2 added values. > > <cffunction name="getAverageTotalCalls" access="public"> > <cfargument name="employeeID" type="numeric" required="yes"> > <cfargument name="dateWorked" type="string" required="yes"> > > <cfquery name="getAverageTotalCalls" datasource="XXXX"> > SELECT avg(da.connects)+avg(sum(ad.acd)) as averageTotalCalls > FROM dialeragent da, agentDaily ad > WHERE da.employeeID = <cfqueryparam value="#arguments.employeeID#" > cfsqltype="CF_SQL_NUMERIC" /> > > </cfquery> > <cfreturn getAverageTotalCalls> > </cffunction> > > So basically, I need to get the average of "connects" (only one record), > get the average of "acd" (can be multiple records so this needs to be summed > first, then averaged) THEN I need to add these two values. > > Here is the error I am getting: > > Error Executing Database Query. > Invalid use of group function > > > Any suggestions? > > TIA > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
