>Hi,
>
[quoted text clipped - 16 lines]
>
>Jeff
Jeff,
I am becoming a little muddled by your description, so will describe a
simple scenario which you can hopefully apply to your own situation.
Assume a repeating table with three columns and you want to sum column
3.
This is one way to do it.
Add an expression box control outside the repeating table.
Click the fx button.
Select the Insert Field or Group button and click on the field (not
the group) for the column.
That will give you something like
my:group1/my:group2/my:field3
Check the edit XPath check box. Edit the XPath as follows:
sum(my:group1/my:group2/my:field3)
The expression box should then contain the sum of the fields in column
3.
Does that help you get to a solution?
Andrew Watt
MVP - InfoPath
Cate - 30 Dec 2004 14:37 GMT
And is there a way to take this one step further? I have two repeating tables
and have got the sum of column 3 from each table in two expression boxes. But
I need to add the total from each expression field together (basically a
subtotal and a subtotal to get a grand total).
Do I need to find a way to nest the both repeating tables and the subtotal
expression fields inside another table?
Thanks,
> >Hi,
> >
[quoted text clipped - 49 lines]
> Andrew Watt
> MVP - InfoPath