Link to home
Start Free TrialLog in
Avatar of ethanjohnsons
ethanjohnsons

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of mkishline
mkishline

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ethanjohnsons
ethanjohnsons

ASKER

great!