[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Totals for conditional sums ?maybe?
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?
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|