I would like to use InfoPath and SharePoint in order to generate and
display some data. The results should be aggregated. The problem I'm
having is the InfoPath merge forms seems to be optimized for
concatenating fields rather than adding them up. For example, if you
have:

billy's expense report >> meals >> $20
fred's expense report >> meals >> $10

The results of "merge forms" is a single form with both billy and
fred's meal line items listed, rather than an item that says

combined expense report >> meals >> $30

The literature I'm (now) looking at seems to confirm this behavior,
such as at
http://office.microsoft.com/en-us/assistance/HA011294451033.aspx ,
where the example in purple shows SharePoint representing the
information as bars. I am looking to aggregate data.

The reason for me posting to this newsgroup is to a) make sure I didn't
miss anything, that InfoPath really does work this way, and b) ask for
suggestions on how to do this, other than creating my own database or
e-mailing excel files back and forth.