Newbie Questions

Re: Repeating Tables

Greg Collins — Fri, 25 Aug 2006 17:20:35 GMT

So it looks like (from your 2nd screenshot) is that you want to get the sum of "Total With VAT" fields and place it in "Total" field. Is this correct?

What I don't understand from the data source images compared with your second screen shot is whether your "Total" field is ALSO inside the repeating "d:SIRF_table" node.... if it is, it doesn't make sense to have it there... becase the grand total would be repeated when it only need be calculated and stored once.

Outside that... it looks like your formula should be:

sum(d:SIRF_table/@Total), but again, I can't be sure from just the visuals...

Here's the steps to do:
1. Right-click the "Total" field and choose Properties.
2. Click the "fx" button to the right of the Value field.
3. Click Insert Function, select "sum" and click OK.
4. Double-click the underlined 'insert field' text inside the sum function.
5. Choose the correct data source and select the d:SIRF_table/@Table field, and click OK 3 times.

Preview -- the "Total" field should now be summing up the row totals.

Re: Repeating Tables

blindfire123 — Wed, 23 Aug 2006 17:47:45 GMT

Yes, it's the bottom repeating table. Is this what you're after:

http://i6.photobucket.com/albums/y214/blindfire123/datasource1.jpg

http://i6.photobucket.com/albums/y214/blindfire123/datasource2.jpg

Re: Repeating Tables

Greg Collins — Wed, 23 Aug 2006 16:36:11 GMT

The visual is helpful -- I'm assuming it is the second (bottom) repeating table. But what I really need to see is the data source tree for that table to have an idea how the nodes are organized before I can know how to help.

Re: Repeating Tables

blindfire123 — Wed, 23 Aug 2006 15:25:02 GMT

Sorry, I'm very new to Infopath, I only started it last week. Could you possibly explain it a little better, possibly in steps?

Here's a screenshot of what it currently looks like(it looks pretty messy at the moment but it's just in draft form):

http://i6.photobucket.com/albums/y214/blindfire123/Infopath2.jpg

I want every number in the column with "Total with Tax" to be added up in the "Total" text box.

Re: Repeating Tables

Greg Collins — Tue, 22 Aug 2006 23:08:24 GMT

Make sure your XPath is correct and that you are using the appropriate namespaces (if required). You need to know where your starting point is for your XPath...

For example your could need to write:

sum(../my:RepeatingNode/@my:Total_Cost)

or

sum(SomeNode/@Total_Cost)

etc.

Re: Repeating Tables

blindfire123 — Tue, 22 Aug 2006 17:05:44 GMT

Actually, ignore that. How do you add all the numbers up in a column when you use a repeating table? I've tried using this forumla but it doesn't work:

sum(@Total_Cost)

Repeating Tables

blindfire123 — Tue, 22 Aug 2006 15:19:40 GMT

When you put a footer on a repeating table, how do you change the fields below into repeating boxes (it's connected to a database). I want it similar to this style:

http://i6.photobucket.com/albums/y214/blindfire123/infopath.jpg