SUM by Group

 <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?
ethanjohnsonsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mkishlineConnect With a Mentor Commented:
<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
 
ethanjohnsonsAuthor Commented:
great!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.