General

Re: Preform pricing total from SharePoint list

lwenzel90 — Thu, 27 Jul 2017 18:08:32 GMT

Thank you so much you are awesome Hilary!

Re: Preform pricing total from SharePoint list

Hilary Stoupa — Thu, 27 Jul 2017 17:55:15 GMT

Paste this in to your FinalTotals default value: sum(xdMath:Eval(xdXDocument:GetDOM("FloorStockData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW, "d:gqyt * d:tpch"))

Re: Preform pricing total from SharePoint list

lwenzel90 — Thu, 27 Jul 2017 12:30:20 GMT

I tried using the sum and eval function but I received this error maybe I am not taking the proper steps. This is the error that I receive: // ggyt is the price from the SP list // tpch is the quantity from the SP list INPUT: sum(eval(SharePointListItem_RW, "gqyt * tpch")) ERROR: Expected value type: , Actual value: name sum(eval(xdXDocument:GetDOM("FloorStockData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW, "xdXDocument:GetDOM("-->FloorStockData

Re: Preform pricing total from SharePoint list

Hilary Stoupa — Wed, 26 Jul 2017 23:58:28 GMT

You will need to use the eval function - if you look back at that sample form, you'll see it as a default in the Total field. Something like: sum(eval(group2, "my:Amount * my:Price"))

You use the field picker to select the repeating group, then hand type the XPath for the other two fields - attach a copy of your form if you need a hand. :)

Re: Preform pricing total from SharePoint list

lwenzel90 — Wed, 26 Jul 2017 19:03:26 GMT

Here is the calculated field math I tried. If you would like me to explain anything further or screenshot anything else I would be happy to!

Preform pricing total from SharePoint list

lwenzel90 — Wed, 26 Jul 2017 18:57:14 GMT

I have an infopath form that pulls data from a SharePoint list for the cost of food items. The form also pulls a quantity field where all items start as zero and that a user can change with a text box later on the form. The items and prices are then displayed in infopath using a repeating section with calculated fields. When I try to create an expression to find a total all of the quantities and their respective prices the expressions is valid but does not update for any value except the first item of the SharePoint list. I am lost and not sure how to calculate a total value. Any help you kind people could offer would be very appreciated.