I don't see any nested loops in the code below. So the simple answer here is to just declare some variables outside of the loop to manage the sums. As long as the variable is outside the loop, you'll be set:
<cfset answervalueTotal = 0 /> <cfset totalforthisquestionTotal = 0 /> <cfset answerpercentageTotal = 0 /> <cfoutput> <cfset answervalueTotal = answervalueTotal + answervalue /> <cfset totalforthisquestionTotal = totalforthisquestionTotal + totalforthisquestion /> <cfset answerpercentageTotal = answerpercentageTotal + answerpercentage /> <table style="float:left; width:50px; text-align:center; font-size:11px; border:1px solid ##CCCCCC; margin:5px; vertical-align:top; background-color:##F7F7F7;"> <tr> <td style="border: 1px solid ##CCCCCC;">#answervalue#</td> </tr> <tr> <td style="border: 1px solid ##CCCCCC;"><strong>#totalforthisquestion#</strong></td> </tr> <tr> <td style="border: 1px solid ##CCCCCC;"><strong>#NumberFormat(answerpercentage, "__ ")#%</strong></td> </tr> </table> </cfoutput> <!--- display sums ---> <cfoutput> #answervalueTotal#<br /> #totalforthisquestionTotal#<br /> #answerpercentageTotal#<br /> <!--- and just for fun, we'll display the average percentage too ---> <cfset averageAnswerPercentage = answerpercentageTotal / yourQuery.recordcount /> #averageAnswerPercentage# </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4