|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Help Please: Sum Amount using XSL
I have the following XML to work with.
<INVOICE> <INVOICEHEADER> <INVOICENUMBER>1</INVOICENUMBER> </INVOICEHEADER> <INVOICE DETAIL> <PROJECT> <TRANSACTIONS> <LINEITEM> <TYPE>Time</TYPE> <AMOUNT>1000</AMOUNT> </LINEITEM> <LINEITEM> <TYPE>Expense</TYPE> <AMOUNT>2000</AMOUNT> </LINEITEM> </TRANSACTIONS> </PROJECT> </INVOICEDETAIL> </INVOICE> <INVOICE> <INVOICEHEADER> <INVOICENUMBER>2</INVOICENUMBER> </INVOICEHEADER> <INVOICE DETAIL> <PROJECT> <TRANSACTIONS> <LINEITEM> <TYPE>Time</TYPE> <AMOUNT>1000</AMOUNT> </LINEITEM> <LINEITEM> <TYPE>Expense</TYPE> <AMOUNT>2000</AMOUNT> </LINEITEM> </TRANSACTIONS> </PROJECT> </INVOICEDETAIL> </INVOICE> In my XSL, I am currently able to loop through the XML and sum the amount of the Time and Expense lineitems separately but am unable to sum the amount for just one invoice at a time. I use the following code for each go around in each Invoice template and it ends up summing the Total for the Time line items for both Invoices. Here is the code I use. Any suggestions? Thank you so much! <!--Define Keys to group LineItem elements for Type--> <xsl:key name="keyType" match="LineItem" use="Type"/> <xsl:element name="Amount"> <!-- Set the Type to a variable --> <xsl:for-each select="//Invoice/InvoiceDetail/Project/Transactions/LineItem[generate-id(.) = generate-id(key('keyType', 'Time')[1])]"> <!--Select all the line items belonging to this type--> <xsl:value-of select="sum(key('keyType', Type)/TotalBaseCurrency)"/> </xsl:for-each> </xsl:element> My email is farr000@yahoo.com |
|
#2
|
||||
|
||||
|
Moved to XML Programming
__________________
Andy Moore << oh no it's got a blog..... Word Press WAP Plugin with Ad Mob Advertising revenue PHP developer deploying ringtones, mp3 downloads and realtones I'm a geek who's obsessed with stats and gadgets |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > XML Programming > Help Please: Sum Amount using XSL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|