How do I Sum fields from different groups into one field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laura - 26 Oct 2006 15:56 GMT

I have developed a status report template in InfoPath. I now need to total
hours that are fields bound to a groups that are in sections. The section
that houses the field for sum total is seperate from all other secions and
group/fields. I am apparently having difficulty comprehending the instruction
for sum, or I am following the wrong instruction for what I require. After
this is all said and done, I plan on exporting weekly status results into an
excel spreadsheet. I know I will be asking questions on that as well.

Reply to this Message

S.Y.M. Wong-A-Ton - 27 Oct 2006 08:02 GMT

It does not sound like you're using repeating groups, but normal groups. The
sum() function works only for nodelists, such as a repeating group. In your
case, you need to add a rule to each of the fields that must be in the
summation to set the value of the total sum field to the sum of all the
fields by using the + operator. So you'd end up with a formula like field1 +
field2 + etc.
---
S.Y.M. Wong-A-Ton

> I have developed a status report template in InfoPath. I now need to total
> hours that are fields bound to a groups that are in sections. The section
[quoted text clipped - 3 lines]
> this is all said and done, I plan on exporting weekly status results into an
> excel spreadsheet. I know I will be asking questions on that as well.

Reply to this Message

Laura - 27 Oct 2006 13:09 GMT

Thank you. I actually looked that up in my XML book yesterday and it was the
one method I did not try. I really appreciate your response. I will try this
method this morning.

> It does not sound like you're using repeating groups, but normal groups. The
> sum() function works only for nodelists, such as a repeating group. In your
[quoted text clipped - 13 lines]
> > this is all said and done, I plan on exporting weekly status results into an
> > excel spreadsheet. I know I will be asking questions on that as well.

Reply to this Message