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

Jacek Dunia wrote:

But my main problem remains, namely how to make other columns per
Technican. When I normal use funcion sum() or count() with function
key() I get values for all technicans, and I would like get for each
technican.
like this:
Name	TotalWorkTimeByIncydent	TotalWorkTimeByFailure	TotalWorkTime	InTime	OutOfTime
Peter		30				0					30				1		1	
Norman		40				150					200				2		1

Does this do what you want?

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform";> <xsl:key name="list" match="/Calls/Row" use="TechnicianName" /> <xsl:output indent="yes"/>

<xsl:template match="Calls"> <html> <body> <table> <thead> <tr> <th>Name</th> <th>Total Work Time</th> <th>Total Work Time INCYDENT</th> <th>Total Work Time FAILURE</th> <th>InTime</th> <th>OutOfTime</th> </tr> </thead> <tbody> <xsl:for-each select="Row[count(. | key('list', TechnicianName)[1]) = 1]"> <tr> <td><xsl:value-of select="TechnicianName" /></td> <td><xsl:value-of select="sum(key('list', TechnicianName)/WorkTime)"/></td> <td><xsl:value-of select="sum(key('list', TechnicianName)[ProblemType = 'INCYDENT']/WorkTime)" /></td> <td><xsl:value-of select="sum(key('list', TechnicianName)[ProblemType = 'FAILURE']/WorkTime)" /></td> <td><xsl:value-of select="count(key('list', TechnicianName)[Rc = 'InTime']/WorkTime)"/></td> <td><xsl:value-of select="count(key('list', TechnicianName)[Rc = 'OutOfTime']/WorkTime)"/></td> </tr>


				</xsl:for-each>
                              </tbody>
                            </table>
			</body>
		</html>
	</xsl:template>
	
</xsl:stylesheet>

--

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

<- Previous	Index	Next ->
Re: [xsl] Problem with sum values w, Jacek Dunia	Thread	Re: [xsl] Problem with sum values w, Jacek Dunia
Re: [xsl] Problem with sum values w, Jacek Dunia	Date	[xsl] How to select for ' in X, Hermann Stamm-Wilbra
	Month

<-prev [Thread] next->	<-prev [Date] next->
Month Index \| List Home