 						<cfif DayRange gt 6><cfset perWeek = 7><cfelse><cfset perWeek = 1></cfif>
 						<cfset avg = (lineTotal / DayRange) * perWeek>
 						<cfif avg lt 1><cfset avgText = "&lt;1"><cfelse><cfset avgText = DecimalFormat(avg)></cfif>
+						<cfset lineValue = lineTotal * val(theProduct.OurPrice)>
+						<cfset totValue += lineValue>
 						<td align="center">#lineTotal#</td>
 						<td>#avgText#</td>
+						<td align="right">&pound;#DecimalFormat(lineValue)#</td>
 					</tr>
 				</cfloop>
 
 				<cfset grandTotal = 0>
 				<tr>
-					<th colspan="4">Totals</th>
+					<th colspan="5">Totals</th>
 					<cfloop from="#startHour#" to="#endHour#" index="i">
 						<cfif StructKeyExists(totals,i)>
 							<cfset hourTotal = StructFind(totals,i)>

	<cfset parm.reportDateTo = form.reportDateTo>
	<cfif len(form.reportDateTo) IS 0><cfset parm.reportDateTo = form.reportDateFrom></cfif>
	<cfquery name="QItemAnalysis" datasource="#parm.datasource#">
		SELECT prodID,prodCatID,prodEposCatID,prodTitle, siUnitSize, eiClass,eiType,eiNet,eiVAT, 
			ehID, ehTimeStamp, DATE(ehTimeStamp) AS yymmdd, HOUR(ehTimeStamp) AS hh, COUNT(*) AS recCount,
            (SELECT pcatTitle FROM tblProductCats WHERE pcatID = prodCatID) AS catTitle,
            (SELECT pgTitle FROM tblProductGroups INNER JOIN tblProductCats on pcatGroup=pgID WHERE pcatID = prodCatID) AS groupTitle

			<cfset DayRange = parm.reportDateTo - parm.reportDateFrom + 1>
			<cfset currProd = 0>
			<cfset totCount = 0>
			<cfset totValue = 0>
			<cfset products = {}>
			<cfset productArray = []>
			<cfset block = {}>
