Subtotals & Grand Total

XML

Expand|Select|Wrap|Line Numbers

 <nodeAA>AA</nodeAA>

    <nodeBB>BB</nodeBB>

        <nodeCC>

            <From>12/05</From>

            <To>11/06</To>

            <Months>12</Months>

            <Amount>10.00</Amount>

            CC

        </nodeCC>

    </nodeBB>

    <nodeDD>DD</nodeDD>

        <nodeEE>

            <From>12/06</From>

            <To>11/07</To>

            <Months>12</Months>

            <Amount>20.00</Amount>

            EE

        </nodeEE>

    </nodeDD>

</nodeAA>

Desired Output
12/05 - 11/06 (12) 0010.00 = 0120.00
12/06 - 11/07 (12) 0020.00 = 0240.00

Grand Total: 0360.00

Nov 28 '08 #1

Follow Post Reply

5698

Dormilich

8,658

Expert Mod 8TB

that seems not that difficult. for the number format you should read about the format-number() function. if you run into problems, we're around to assist you.

regards

Nov 28 '08 #2

jkmyoung

2,057

Expert 2GB

Agreed, most of it is easy, up to the grand total part.
For this, there are 2 recommended methods:
1. Recursive template, adding up the product from each part, pass sum as parameter or result
2. Create a temporary variable with the products. Then sum up using the sum function and the node-set function if necessary.

1. Pros: does not require extension functions.
Cons: uses more memory. Can break if there are too many nodes to calculate.

2. Pros: Requires only single pass.
Cons: Requires use of XSLT 2.0, or the node-set extension function, which differs across processors.

quick example of 1:

Expand|Select|Wrap|Line Numbers

 
<xsl:template name="addProducts">

  <xsl:variable name="currentProduct" select="(*/Months) * (*/Amount)"/>

  <xsl:choose>

    <xsl:when test="not(following-sibling::*)">

      <xsl:value-of select="$currentProduct"/>

   </xsl:when>

   <xsl:otherwise>

      <xsl:variable name="$nextProductSums">

         <xsl:for-each select="following-sibling::*[1]">

            <xsl:call-template name="addProducts"/>

         </xsl:for-each>

       </xsl:variable>

      <xsl:value-of select="$nextProductSums + $currentProduct"/>

  </xsl:otherwise>

  </xsl:choose>

</xsl:template>

Quick example of 2:

Expand|Select|Wrap|Line Numbers

 
<xsl:variable name="products">

   <xsl:for-each select="*">

       <node>

         <xsl:value-of select="(*/Months) * (*/Amount)"/>

       </node>

  </xsl:for-each>

</xsl:variable>
 
<xsl:value-of select="sum($products/node)"/>

Dec 1 '08 #3

Imaginativeone

* Note * I had to remove the $'s at lines 5 and 8 of example 1. I'm forced to use xml version 1.0

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="iso-8859-1"?>

<xsl:stylesheet

    version="1.0"

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
    <xsl:template match="/">

        <html>

            <body>

                <head>

                    <title>PHUS Transformation</title>

                </head>

                <h1>PHUS Transformation</h1>

                <!-- <xsl:apply-templates select="PHUS/pBICYEAR"/> -->

                <xsl:apply-templates select="PHUS"/>

            </body>

        </html>

    </xsl:template>
 
    <xsl:template match="pBICYEAR">
 
            <!-- pBICYEAR attribute: pBicYearData, child node of pBICYEAR -->

            <xsl:for-each select="@pBicYearData">
 
                <!-- Tax Year Headers -->

                <font size="6"><b><xsl:value-of select="." /></b></font><br/>
 
            </xsl:for-each>
 
                <!-- pTRANS node: child node of pBICYEAR -->

                <xsl:for-each select="pTRANS">

                    <font color="brick"><xsl:value-of select="@TransData" /></font><br/>
 
                    <!-- Event Data -->

                    <xsl:for-each select="pEVNT">

                        <font color="red">

                            <xsl:value-of select="EventID" />*

                            <xsl:value-of select="Description" />*

                            <xsl:value-of select="From" />*-

                            <xsl:value-of select="To" />*

                            (<xsl:value-of select="ElapsedMonths" />)*

                            <xsl:value-of select="Amount" /> *
 
                            <xsl:value-of select = "format-number(ElapsedMonths * Amount, '#######.00')"/>
 
                        </font><br/>

                    </xsl:for-each><br/>
 
                </xsl:for-each>
 
    </xsl:template>
 
    <xsl:template name="addProducts">

      <xsl:variable name="currentProduct" select="(*/ElapsedMonths) * (*/Amount)"/>

      <xsl:choose> 

       <xsl:when test="not(following-sibling::*)"> 

         <xsl:value-of select="currentProduct"/> 

      </xsl:when> 

       <xsl:otherwise> 

         <xsl:variable name="nextProductSums"> 

            <xsl:for-each select="following-sibling::*[1]"> 

               <xsl:call-template name="addProducts"/> 

            </xsl:for-each> 

          </xsl:variable> 

         <xsl:value-of select="$nextProductSums + $currentProduct"/> 

      </xsl:otherwise> 

      </xsl:choose> 

    </xsl:template>   
 
</xsl:stylesheet>
 
<!-- This template is placed here for reference -->

<!-- <xsl:template name="addProducts"> 

  <xsl:variable name="currentProduct" select="(*/Months) * (*/Amount)"/> 

  <xsl:choose> 

    <xsl:when test="not(following-sibling::*)"> 

      <xsl:value-of select="$currentProduct"/> 

   </xsl:when> 

   <xsl:otherwise> 

      <xsl:variable name="$nextProductSums"> 

         <xsl:for-each select="following-sibling::*[1]"> 

            <xsl:call-template name="addProducts"/> 

         </xsl:for-each> 

       </xsl:variable> 

      <xsl:value-of select="$nextProductSums + $currentProduct"/> 

  </xsl:otherwise> 

  </xsl:choose> 

</xsl:template> -->

Dec 1 '08 #4

Subtotals & Grand Total

Post your reply

Similar topics