XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Diarmuid O ConnorSubject: 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

Postnext
James DurningSubject: 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)"/>

Postnext
Diarmuid O ConnorSubject: XSLT totaling numeric values
Author: Diarmuid O Connor
Date: 28 Oct 2008 01:25 PM
Thanks mate !!

Posttop
Diarmuid O ConnorSubject: 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 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.