InfoPath Dev

I have two repeating tables with three columns, the last column is cost. I'm able to sum all of the entries from cost column from table A and the first entry of table B.

Is there anyway to sum all cost entries from both tables.

Many Thanks,

Emilia

Hello Emilia and Welcome to Forums,
You can add the entries of cost column from table A and first entry of table B by following these steps:
1. Double click the text box where you want to display the total cost
2. Click on fx button besides Value text box in Text Box Properties window
3. Click on Insert Function in Insert Formula window
4. Select Math from Categories, Sum from Functions and click on OK button
5. Double click on “double click to insert field” link and select the cost field from the first repeating table and click on OK button
6. Enter “+” symbol and again click on “Insert Function” button
7. Select Math from Categories, Sum from Functions and click on OK button
8. Double click on “double click to insert field” link and select the cost field from the second repeating table and click on OK button
9. Remove “sum” text for the second field and click OK for two times
The formula in Value field should be some thing like this “sum(field3)+(field6)”

Hope this helps!

Thank you for your reply Shailaja.

I have been following this method but it appears not to work as it sums all of the entries from cost field table A and only the first cost field from table B. Is there anyway for it to total all entries from both tables.

Hi Emilia,

For all entries of cost fields sum from Table A and Table B you can change the your formula as "sum(field3) + sum(field6)" as Shailaja explained above. From this you can get the all the entries of sum.