|
Subject: [xsl] Newbie help / Grouping and sum From: "Kirov Plamen" <pkirov@xxxxxxxxx> Date: Thu, 14 Sep 2006 16:27:27 +0300 |
In XSLT ver 1.0.
Here is XML I have:
<CustRef>
<Contract>
<ContractId>1</ContractId>
<SumItem>
<SumItemResult>
<AggSetSumItem>
<Days>1</Days>
<Service>TT</Service>
</AggSetSumItem>
<Charge>
<Amount>40.00</Amount>
</Charge>
</SumItemResult>
</SumItem>
<SumItem>
<SumItemResult>
<AggSetSumItem>
<Days>1</Days>
<Service>TE</Service>
</AggSetSumItem>
<Charge>
<Amount>240.00</Amount>
</Charge>
</SumItemResult>
</SumItem>
<SumItem>
<SumItemResult>
<AggSetSumItem>
<Service>TT</Service>
</AggSetSumItem>
<Charge>
<Amount>880.00</Amount>
</Charge>
</SumItemResult>
</SumItem>
</Contract>
<Contract>
<ContractId>2</ContractId>
<SumItem>
<SumItemResult>
<AggSetSumItem>
<Days>1</Days>
<Service>TT</Service>
</AggSetSumItem>
<Charge>
<Amount>0.50</Amount>
</Charge>
</SumItemResult>
</SumItem>
<SumItem>
<SumItemResult>
<AggSetSumItem>
<Days>1</Days>
<Service>TT</Service>
</AggSetSumItem>
<Charge>
<Amount>350.20</Amount>
</Charge>
</SumItemResult>
</SumItem>
<SumItem>
<SumItemResult>
<AggSetSumItem>
<Service>TZ</Service>
</AggSetSumItem>
<Charge>
<Amount>880.00</Amount>
</Charge>
</SumItemResult>
</SumItem>
</Contract>
</CustRef>
I want to group by <ContractId> and sum <Amount> where <Service> is 'TT'
and <Days> is greater than 0. For example:
1 40
2 350.70
Using Muenchian method, I can sum the <Amount> for every <ContractId>,
but am can't sum only these <Amount> for which <Service> is equal to
'TT' and <Days> is greater than 0.
Any help is appreciated.
10x in advance.
Plamen
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| Re: [xsl] SSI echo as an attribute , David Carlisle | Thread | Re: [xsl] Newbie help / Grouping an, David Carlisle |
| Re: [xsl] Grouping the elements, Abel Braaksma | Date | Re: [xsl] SSI echo as an attribute , David Carlisle |
| Month |