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

[Laura]

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.

 

[S.Y.M. Wong-A-Ton]

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.

 

[Laura]

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.