Newbie Questions

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Thu, 04 May 2017 16:22:56 GMT

Wonderful, glad that did it - oh, and here is an oldie but goodie blog post by Greg Collin's on preceding-sibling that I always find helpful as well:

http://www.infopathdev.com/blogs/greg/archive/2005/06/13/Using-XPath_2700_s-_2700_preceding_2D00_sibling_2700_-Axis-Correctly.aspx

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Thu, 04 May 2017 16:17:43 GMT

YEESSS!!! That worked. Thank you again. I truly appreciate the assistance you and your staff provide here, you're lifesavers.

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Wed, 03 May 2017 17:19:20 GMT

Maybe try setting a rule on hwprice & swprice to set the total?

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Wed, 03 May 2017 17:12:31 GMT

Yes, it did it for me too when entering values directly into the hardware and software fields. This form I sent though was without the data connections. Previewing on the server, my list populates the hardware, software, etc boxes and when an item is selected its value appears in the hardware and software boxes but the total cost. It never populated with anything. It looks like the values aren't being passed to the total when they are not directly input (or in my case a result of a previous calculation). Thank you again.

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Tue, 02 May 2017 22:52:24 GMT

That is strange. I notice when I preview it, if I type in the Hardware cost, it shows in the total (as expected).

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Tue, 02 May 2017 16:04:41 GMT

Here it is.

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Mon, 01 May 2017 22:43:41 GMT

Hi, I will first thing tomorrow.

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Mon, 01 May 2017 21:06:59 GMT

That seems very odd! Any chance you can attach a copy of your form under the Options tab in a reply?

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Mon, 01 May 2017 19:53:24 GMT

Yes they are exactly the same. When I preview, the calculations are performed for each field and the sums are populated. I also set the total cost default value to hwprice once without any calculations and it was blank.

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Mon, 01 May 2017 19:23:51 GMT

So hwprice & swprice are fields that are using similar defaults for their values? Do both fields have values if you put them on the form to take a look at them?

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Mon, 01 May 2017 18:14:29 GMT

Thanks again for your assistance Friday. Well, I'm trying to build on that success. I have a total of four multiple-selection list boxes for which I am calculating a total. I would like to calculate the sum all of these list box totals. All fields have a data type of decimal (double). The formula I'm using for the default value of my grand total field at this stage is hwprice + swprice. However, upon preview the grand total field is blank. Can the results of my lists box calculation be used in another calculation?

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Fri, 28 Apr 2017 18:29:40 GMT

Wonderful - glad that worked! The XPath filter (in the square brackets) indicates which repeating nodes you want from your data source. Current() refers to the node where we are putting the formula. :)

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Fri, 28 Apr 2017 18:00:23 GMT

Oh my goodness, thank you!!!!!!! My eye just teared up ;-) You have made my weekend, I hope you have a great one!

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

Hilary Stoupa — Fri, 28 Apr 2017 17:56:43 GMT

Try this: sum(xdXDocument:GetDOM("Standard Hardware")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Title = current()/../my:computerhardware]/d:Price)

Re: Calculate Totals From Sharepoint List Repeating Table & Multiple-Selection List Box

mgrant50 — Fri, 28 Apr 2017 17:51:39 GMT

Hi, it is: sum(xdXDocument:GetDOM("Standard Hardware")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[xdXDocument:GetDOM("Standard Hardware")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Title = ../my:computerhardware]/xdXDocument:GetDOM("Standard Hardware")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Price) I now receive a node-test expected error. Thank you