I'm working on generating a sum of element names that when they exist increment up.
XML Example:
<Distributions> <DIST_DISTRIBUTIONMETHOD_1>Check to Other</DIST_DISTRIBUTIONMETHOD_1> <DIST_CREDITOR_1>MOTORS FINANCE</DIST_CREDITOR_1> <DIST_AMOUNT_1>16710.04</DIST_AMOUNT_1> <DIST_NET_1>No</DIST_NET_1> <DIST_DISTRIBUTIONMETHOD_2>Check to Other</DIST_DISTRIBUTIONMETHOD_2> <DIST_CREDITOR_2>WILLIAM HOOK</DIST_CREDITOR_2> <DIST_AMOUNT_2>1239.86</DIST_AMOUNT_2> <DIST_NET_2>Yes</DIST_NET_2> </Distributions>
I need to Sum DIST_AMOUNT_1, 2, etc, up to a possible 15 in total that may or may not exist.
Thusfar, I've assigned each DIST_AMOUNT to a variable after checking to see if it exists. The sum itself is where I'm having issues as there is nothing populating for the sum and I've no idea why, I've beaten my head on this and googled for answers for days now. Any help is appreciated.
My XSL code thusfar:
<xsl:variable name="DIST_TMP_1"> <xsl:choose> <xsl:when test="//DIST_AMOUNT_1"> <xsl:value-of select="number(//DIST_AMOUNT_1)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="number(0.00)"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="DIST_TMP_2"> <xsl:choose> <xsl:when test="//DIST_AMOUNT_2"> <xsl:value-of select="number(//DIST_AMOUNT_2)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="number(0.00)"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="DIST_TMP_3"> <xsl:choose> <xsl:when test="//DIST_AMOUNT_3"> <xsl:value-of select="number(//DIST_AMOUNT_3)"/> </xsl:when> <xsl:otherwise> <xsl:value-of select="number(0.00)"/> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:element name="ECD070_TOTAL_VAR"> <xsl:value-of select="sum($DIST_TMP_1+$DIST_TMP_2+DIST_TMP_3)"/> </xsl:element>
No comments:
Post a Comment