[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
[xsl] RE: Totals for conditional sums ?maybe?
Subject: [xsl] RE: Totals for conditional sums ?maybe? From: "Christopher Pierce" <Christopher.Pierce@xxxxxxxxxxx> Date: Tue, 6 Dec 2005 13:06:11 -0500 |
Data: <AwardFullData> <AwardItemizedLine> <periodLinePeriodNumber></periodLinePeriodNumber> <transactionAmount>$1,804.00</transactionAmount> </AwardItemizedLine> <AwardItemizedLine> <periodLinePeriodNumber></periodLinePeriodNumber> <transactionAmount>$600.00</transactionAmount> </AwardItemizedLine> <AwardItemizedLine> <periodLinePeriodNumber>1</periodLinePeriodNumber> <transactionAmount>$600.00</transactionAmount> </AwardItemizedLine> <AwardItemizedLine> <periodLinePeriodNumber>2</periodLinePeriodNumber> <transactionAmount>$600.00</transactionAmount> </AwardItemizedLine> ...... </AwardFullData> This statement strips all non-numeric characters (haven't made it to reformating back to $###,###.## yet): <xsl:value-of select="(translate(//AwardFullData/AwardItemizedLine/transactionAmount,t ranslate(//AwardFullData/AwardItemizedLine/transactionAmount,'0123456789 ', ''), ''))"/> Result when applied to data: 180400 This statement is supposed to sum transactionAmount where count of periodLinePeriodNumber <1 <xsl:value-of select="sum(translate(//AwardFullData/AwardItemizedLine[count(./periodLi nePeriodNumber)<1]/transactionAmount,translate(//AwardFullData/AwardI temizedLine[count(./periodLinePeriodNumber)<1]/transactionAmount,'012 3456789', ''), ''))"/> Result when applied to data: Can not convert #STRING to a NodeList! Any suggestions?
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] RE: Totals for conditiona, Michael Kay | Thread | RE: [xsl] RE: Totals for conditiona, Michael Kay |
Re: [xsl] wordml to docbook, Jon Gorman | Date | RE: [xsl] RE: Totals for conditiona, Haarman, Michael |
Month |