Re: [xsl] Problem with sum values with double param

Cart

XML Editor - Download a Free Trial >

See What's New >

Buy Now >

[Home] [By Thread] [By Date] [Recent Entries]

Subject: Re: Problem with sum values with double param
From: Martin Honnen <Martin.Honnen@xxxxxx>
Date: Wed, 05 Aug 2009 15:52:42 +0200

Jacek Dunia wrote:

<Calls>
	<Row NR="1">
		<Rc>InTime</Rc>
		<WorkTime>20</WorkTime>
		<TechnicianName>Norman</TechnicianName>
		<ProblemType>INCYDENT</ProblemType>
	</Row>
	<Row NR="2">
		<Rc>OutTime</Rc>
		<WorkTime>10</WorkTime>
		<TechnicianName>Peter</TechnicianName>
		<ProblemType>INCYDENT</ProblemType>
	</Row>
	<Row NR="3">
		<Rc>InTime</Rc>
		<WorkTime>150</WorkTime>
		<TechnicianName>Norman</TechnicianName>
		<ProblemType>FAILURE</ProblemType>
	</Row>
	<Row NR="4">
		<Rc>OutOfTime</Rc>
		<WorkTime>10</WorkTime>
		<TechnicianName>Norman</TechnicianName>
		<ProblemType>RemoteAccess</ProblemType>
	</Row>
	<Row NR="5">
		<Rc>InTime</Rc>
		<WorkTime>20</WorkTime>
		<TechnicianName>Norman</TechnicianName>
		<ProblemType>INCYDENT</ProblemType>
	</Row>
	<Row NR="6">
		<Rc>InTime</Rc>
		<WorkTime>20</WorkTime>
		<TechnicianName>Peter</TechnicianName>
		<ProblemType>INCYDENT</ProblemType>
	</Row>
I would like get following out put
Name	TotalWorkTimeByIncydent	TotalWorkTimeByFailure	TotalWorkTime	InTime	OutOfTime
Peter		30			0			30	1	1	
Norman		40			150			200	2	1

Thecnican name can't be duplicate so I make like this:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	
	<xsl:key name="list" match="/Activities/Row" use="TechnicianNames" />

The root element you show in your XML sample is named 'Calls', not 'Activities' so I would expect match="Calls/Row".

<xsl:template match="Activities">

Same here, shouldn't that be match="Calls"?

		<html>
			<body>
				<xsl:variable name="var_TechnicianNamess"
select="/Activities/Row[count(. | key('list', TechnicianName)[1]) =
1]"/>
				<xsl:for-each select="$var_TechnicianNamess">
					<xsl:value-of select="TechnicianName" />
					<xsl:value-of select="sum(WorkMinute)" />

I think you want <xsl:value-of select="sum(key('list', TechnicianName)/WorkMinute)"/>

to sum up the WorkMinute(s) for each Technician.

--

	Martin Honnen
	http://msmvps.com/blogs/martin_honnen/

Current Thread
Problem with sum values with double param Jacek Dunia - 5 Aug 2009 13:39:31 -0000 Martin Honnen - 5 Aug 2009 13:53:09 -0000 <= Jacek Dunia - 5 Aug 2009 15:09:53 -0000 Martin Honnen - 5 Aug 2009 16:50:05 -0000 Jacek Dunia - 5 Aug 2009 18:24:24 -0000

<- Previous	Index	Next ->
Problem with sum values with , Jacek Dunia	Thread	Re: Problem with sum values w, Jacek Dunia
Problem with sum values with , Jacek Dunia	Date	Re: Problem with sum values w, Jacek Dunia
	Month

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >