Displaying totals by grouping

[Ibrahim Gokalp]

Hi,

I have branch id, account id and amount fields in my schema. I want to show
a summary of total amounts grouped by branch id field.

Is it possible with InfoPath?

Regards,

Ibrahim Gökalp

 

[Josh Bertsch [MSFT]]

Sure. Using a calculation on a text box, you could do something like:

sum(../my:group1/my:amount[../my:branch_id = "abc123"])

This XPath basically says, sum all of the amounts where the associated
branch_id is equal to "abc123"

--josh bertsch

 

[Ibrahim Gokalp]

This is not what I want. I try to give an example of what I want to perform.

For example, my raw xml data is as follows;

<Payment>
<Branch>11</Branch>
<Amount>161</Amount>
</Payment>
<Payment>
<Branch>13</Branch>
<Amount>100</Amount>
</Payment>
<Payment>
<Branch>11</Branch>
<Amount>55</Amount>
</Payment>

I want to summarize these values and show it in InfoPath form as follows;

Branch Id Total Amount
11 216
13 100

Regards,

Ibrahim Gokalp

Sure. Using a calculation on a text box, you could do something like:

sum(../my:group1/my:amount[../my:branch_id = "abc123"])

This XPath basically says, sum all of the amounts where the associated
branch_id is equal to "abc123"

--josh bertsch

Hi,

I have branch id, account id and amount fields in my schema. I want to
show
a summary of total amounts grouped by branch id field.

Is it possible with InfoPath?

Regards,

Ibrahim Gökalp

 

[mcchu]

Hi Ibrahim,

Have you figured out anything?

I am trying to do the same thing. I am very stuck on this.

Any hint or clue will be greatly appreciated.

Regards