RE: [xsl] Totalling A Set of Values

["Allistair Crossley" <Allistair.Crossley@xxxxxxx>]

Yes, I figured this too

<xsl:variable name="deptTotalFullDays" select="
count(//employee[@department = $deptName]/approvals/approval[@type = 'F']) +
(count(//employee[@department = $deptName]/approvals/approval[@type = 'H']) div 2 )+
(count(//employee[@department = $deptName]/approvals/approval[@type = 'Y']) div 2)
" />

Also, I know - this is not the real date format! FYI I use both a milliseconds timestmap and format dd/mm/yyyy. In addition, the point you make about 1 country is totally invalid since 1) this is an intranet application that will never be used out of the UK and 2) Even it I wanted to port this outside, I could easily change this format. But in anycase, this is not the format I use.

-----Original Message-----
From: David Carlisle [mailto:davidc@xxxxxxxxx]
Sent: 13 June 2003 13:05
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: Re: [xsl] Totalling A Set of Values


 <holiday date="120603" type="X" />

 > At the end of each department I need to total the number of X days. I
 > am hoping there is a nice elegant way to do this but I do not know
 > how. I do know I cannot incremement a variable because I tried this
 > and also read it. 

I think you just want
 select="count(employee[@department='sales']/holiday[@type='X'])
to get the sum of all holidays of that type by all emplyees in the sales
department.


David

(horrible format for dates by the way, only understandable in one
country, and not Y2K+100 compliant)

________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> 
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com";>www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list