Solved

# SUM by Group

Posted on 2006-07-03
Medium Priority
562 Views
<cfoutput group="ReferralSourceIntake" query="......">
<tr bgcolor="FFFFCC">
<td>#ReferralSourceIntake#</td>
<cfSet count = 1>
<cfoutput>
<cfif count NEQ 1>
</tr>
<tr>
<td>&nbsp;</td>
</cfif>

<td>#dateformat("#IntakeDate#", "mm/dd/yyyy")#</td>
<td>#TheCount#</td>
</tr>
<cfset count = count + 1>
</cfoutput>
</cfoutput>

I want to put SUM (= SUM of #TheCount#) of each group at the end of each group section.
How do you accomplish this?
0
Question by:ethanjohnsons
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 12

Accepted Solution

mkishline earned 2000 total points
ID: 17032001
<cfoutput group="ReferralSourceIntake" query="......">
<tr bgcolor="FFFFCC">
<td>#ReferralSourceIntake#</td>
<cfset groupcount = 0 />
<cfSet count = 1>
<cfoutput>
<cfif count NEQ 1>
</tr>
<tr>
<td>&nbsp;</td>
</cfif>

<td>#dateformat("#IntakeDate#", "mm/dd/yyyy")#</td>
<td>#TheCount#</td>
</tr>
<cfset count = count + 1>
<cfset groupcount = groupcount + TheCount />
</cfoutput>
#GroupCount#
</cfoutput>
0

Author Comment

ID: 17032247
great!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
###### Suggested Courses
Course of the Month13 days, 23 hours left to enroll