Hello Xsl-list,
I'm using Xslt v1 and doing a transform to Xhtml with .net
output shard
<tr>
<th>Amex</th>
<th>MasterCard</th>
<th>Visa</th>
</tr>
<tr>
<th>1</th>
<th>13</th> (e.g. 9+4)
<th>7</th>
</tr>
Just focusing on MasterCard.
<xsl:variable name="totalMasterCard"
select="sum(/leaderBoard/Table1/countType[parent::node()/productType[='MasterCard'])"/>
I'm trying to sum "countType" for Table1 elements where
productCategory=MasterCard.
Its not parsing.
What's the correct grammar for this?
I think of it as: Find all parent nodes of node where productType=MasterCard.
Sum "countType" nodes of parent node.
If "countType" GT 0 there will always be a "productType" sibling above it.
Xml shard
<leaderBoard>
...
<Table1>
<productCategory>CreditCard</productCategory>
<productType>Amex</productType>
<countType>1</countType>
<countLeadSource>1</countLeadSource>
<countRadioStation>1</countRadioStation>
</Table1>
<Table1>
<productCategory>CreditCard</productCategory>
<productType>MasterCard</productType>
<countType>9</countType>
<leadSource>Radio</leadSource>
<countLeadSource>9</countLeadSource>
<radioStation>Smooth FM</radioStation>
<countRadioStation>9</countRadioStation>
</Table1>
<Table1>
<productCategory>CreditCard</productCategory>
<productType>MasterCard</productType>
<countType>4</countType>
<leadSource>Radio</leadSource>
<countLeadSource>4</countLeadSource>
<radioStation>TFM/Magic 1170</radioStation>
<countRadioStation>4</countRadioStation>
</Table1>
<Table1>
<productCategory>CreditCard</productCategory>
<productType>Visa</productType>
<countType>7</countType>
<leadSource>Radio</leadSource>
<countLeadSource>7</countLeadSource>
<radioStation>Smooth FM</radioStation>
<countRadioStation>7</countRadioStation>
</Table1>
<Table1>
<productCategory>LoanClaim</productCategory>
<productType>Secured Loan</productType>
<countType>1</countType>
<countLeadSource>1</countLeadSource>
<countRadioStation>1</countRadioStation>
</Table1>
...
</leaderBoard>
--
Best regards,
Arthur mailto:ArthurM(_at_)seipas(_dot_)com
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--