Hello..
I'm trying to get the grand total of all the columns using XSLT.  This this possible and how would I accomplish this?

Location 1	200
Location 2	300
Locaiton 3	50
Grand Total	550

Thanks.. -Jeff

Hello Stefan,
Thank you for the reply.
I tried what you suggested, but it's reporting '0' as the sum.
Not sure why isn't not working properly.  The columns I'm trying to add, etc are integers.
Thanks.. -Jeff

Below is the XSL code I'm trying to use.

Template:
  <td>
    <xsl:value-of select="format-number(udt:Population, '#,###.##')" disable-output-escaping="yes" />
  </td>

Below the Apply-Template:
  <td class="TopRow">
    <xsl:value-of select="sum(//udt:data/udt:Population)" />
  </td>

Hello Stefan..
Thank you again for your reply..  I was able to get everything working properly..
For anyone which is wondering how the final XSL looks, see below.  -Jeff
____________________________________________________________
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:udt="DotNetNuke/UserDefinedTable" exclude-result-prefixes="udt">
  <xsl:output method="xml" indent="yes" omit-xml-declaration="yes" />
  <!--
  This prefix is used to generate module specific query strings
  Each querystring or form value that starts with udt_{ModuleId}_param 
  will be added as parameter starting with param
  -->
  <xsl:variable name="prefix_param">udt_<xsl:value-of select="//udt:Context/udt:ModuleId" />_param</xsl:variable>


  <xsl:template match="udt:Data" mode="list">
    <tr class="Normal">
      <td class="LeftRow">
        <xsl:call-template name="EditLink" />&#160;
        <xsl:value-of select="udt:Community" disable-output-escaping="yes" /></td>
      <td>
        <xsl:value-of select="format-number(udt:Population, '#,###.##')" disable-output-escaping="yes" />
      </td>
      <td>
        <xsl:value-of select="format-number(udt:Male, '#,###.##')" disable-output-escaping="yes" />
      </td>
      <td>
        <xsl:value-of select="format-number(udt:Female, '#,###.##')" disable-output-escaping="yes" />
      </td>
      <td>
        <xsl:value-of select="format-number(udt:Total_x0020_Households, '#,###.##')" disable-output-escaping="yes" />
      </td>
      <td>
        <xsl:value-of select="format-number(udt:Average_x0020_Household_x0020_Size, '#,###.##')" disable-output-escaping="yes" />
      </td>
      <td>
        <xsl:value-of select="format-number(udt:Total_x0020_Families, '#,###.##')" disable-output-escaping="yes" />
      </td>
      <td>
        <xsl:value-of select="format-number(udt:Average_x0020_Family_x0020_Size, '#,###.##')" disable-output-escaping="yes" />
      </td>
    </tr>
  </xsl:template>


  <xsl:template match="/udt:UserDefinedTable">
    <xsl:variable name="currentData" select="udt:Data" />
    <xsl:if test="$currentData">
      <table class="CensusTable" border="1">
        <tr>
          <td style="border-color: #ffffff;">
            &#160;
          </td>
          <td class="TopRow">
            Population
          </td>
          <td class="TopRow">
            Male
          </td>
          <td class="TopRow">
            Female
          </td>
          <td class="TopRow">
            Total Households
          </td>
          <td class="TopRow">
            Average Household Size
          </td>
          <td class="TopRow">
            Total Families
          </td>
          <td class="TopRow">
            Average Family Size
          </td>
        </tr>
        <xsl:apply-templates select="$currentData" mode="list">
        </xsl:apply-templates>
        <tr>
          <td class="LeftRow">
            Totals
          </td>
          <td>
              <xsl:value-of select="format-number(sum(//udt:Data/udt:Population), '#,###.##')" />
          </td>
          <td>
              <xsl:value-of select="format-number(sum(//udt:Data/udt:Male), '#,###.##')" />
          </td>
          <td>
              <xsl:value-of select="format-number(sum(//udt:Data/udt:Female), '#,###.##')" />
          </td>
          <td>
              <xsl:value-of select="format-number(sum(//udt:Data/udt:Total_x0020_Households), '#,###.##')" />
          </td>
          <td>
              <xsl:value-of select="format-number((sum(//udt:Data/udt:Population)) div (sum(//udt:Data/udt:Total_x0020_Households)), '#,###.##')" />
          </td>
          <td>
              <xsl:value-of select="format-number(sum(//udt:Data/udt:Total_x0020_Families), '#,###.##')" />
          </td>
          <td>
              <xsl:value-of select="format-number((sum(//udt:Data/udt:Population)) div (sum(//udt:Data/udt:Total_x0020_Families)), '#,###.##')" />
          </td>
        </tr>
      </table>
    </xsl:if>
  </xsl:template>


  <xsl:template name="EditLink">
    <xsl:if test="udt:EditLink">
      <a href="{udt:EditLink}">
        <img border="0" alt="edit" src="{//udt:Context/udt:ApplicationPath}/images/edit.gif" />
      </a>
    </xsl:if>
  </xsl:template>
</xsl:stylesheet>