Hello Michael,

Thanks Mike
I'm sure what you sent will work.
Note your comments will modify  what I send in future.

Thursday, June 12, 2008, 8:22:53 AM, you wrote:

>> I'm trying to sum "countType" for Table1 elements where
>> productCategory=MasterCard.
>> Its not parsing.
>> What's the correct grammar for this?

> It's much more productive to show us your code and the error message. Then
> we can see where your misunderstandings lie, and we can try to explain what
> you've misunderstood. For example, you might have the right expression, but
> be executing it in the wrong context.

> In the meantime, use

> sum(Table1[productType='Amex']/countType)

> with leaderBoard as the context node.

> Michael Kay
> http://www.saxonica.com/


>> 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@xxxxxxxxxx


> !DSPAM:4850cef3122436568615745!





--
Best regards,
 Arthur                            mailto:ArthurM@xxxxxxxxxx