SSDN - XSLT totaling numeric values

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Diarmuid O Connor

Subject: XSLT totaling numeric values
Author: Diarmuid O Connor
Date: 28 Oct 2008 07:39 AM

Hi

A section of my XML file in this format:
<Policies>
<Policy>
<ID>1239<ID>
<Status>A<Status>
<Vaue>25600<Value>
<Policy>
<Policy>
<ID>1241<ID>
<Status>B<Status>
<Vaue>57000<Value>
<Policy>
<Policy>
<ID>1246<ID>
<Status>A<Status>
<Vaue>12399<Value>
<Policy>
<Policy>
<ID>1267<ID>
<Status>C<Status>
<Vaue>1900<Value>
<Policy>
<Policy>
<ID>1304<ID>
<Status>B<Status>
<Vaue>22450<Value>
<Policy>
<Policy>
<ID>1389<ID>
<Status>D<Status>
<Vaue>89000<Value>
<Policy>
<Policies>

All the policy nodes have a Status and a Value.

I want to be able to calculate the following totals:
total value for all policies with Status A
total value for all policies with Status B and C

How do I do this?

Any help would be appreciated.
Thanks

James Durning

Subject: XSLT totaling numeric values
Author: James Durning
Date: 28 Oct 2008 12:31 PM

<xsl:value-of select="sum(//Policy[Status='A']/Value)"/>

<xsl:value-of select="sum(//Policy[Status='B' or Status='C']/Value)"/>

Diarmuid O Connor

Subject: XSLT totaling numeric values
Author: Diarmuid O Connor
Date: 28 Oct 2008 01:25 PM

Diarmuid O Connor

Subject: XSLT totaling numeric values
Author: Diarmuid O Connor
Date: 24 Nov 2008 11:12 AM

As a follow on to this, if each Policy node also contained a <Type> value

How could I caculate a sum based on the Status and Type value, for example if I wanted to calculate the total value for all policies with Status = "B" and Type "New"

I have tried
<xsl:value-of select="sum(//Policy[Status='B' and Type='New']/Value)"/>

but this gives an Invalid Xpath Expression error

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.