How to get sum of attributes under a node?

[nitin403]

Hi! to all.

I need get total of amount in a node.

Below is an sample of my xml datasource.

Code:

<A>
<B Amount="20" />
<B Amount="20" />
<B Amount="20" />
<B Amount="20" />
<B Amount="20" />
<B Amount="20" /> 
<B Amount="20" /> 
<B Amount="20" />
</A>

 

My Query string is /A

 

I want to take /A/B as An Object and get the summation of /B/@Amount attribute.

How can I do this.

I use iReport.

 

Thanks for your help in advance.

[nitin403]

I found the solution to it.

 

I just need to create a field.

And in field discription type sum(A/B//@amount) and

:woohoo: it works