InfoPath Dev

Hello, I've been thrown into the fire with very little experience in InfoPath. I want to display the total cost from a user's multiple-selection list box selections. Google let me to this post http://www.infopathdev.com/forums/p/13888/49351.aspx which has the solution I need. I believe I duplicated the SumRepList.xsn as Jimmy presented. However, in my case my secondary data comes from a SharePoint list. I noticed was Jimmy's secondary data source (product) is a field and my source is a group (from the SP list). Jimmy's formula was sum(product[@name = selectedItems]/@price) and mine is sum(SharePointListItem_RW[Title = computerhardware]/Price). SharePointListItem_RW is my secondary group. The error in verifying the formula I now receive is "SharePointListItem_RW/Title" does not point to a valid location path of a field or group. I'm not sure why as I selected it by choosing insert field or group. Many thanks in advance!

If you click Edit XPath in the formula window, what's the resulting XPath? Can you paste it in a reply?

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

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

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

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. :)

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?

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?

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.

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

Hi, I will first thing tomorrow.

Here it is.

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

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.

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