InfoPath Dev

Hello,

I'm trying to get the order total and using an XPath as an example from the InfoPath Team Blog in an Expression Box:

sum(xdMath:Eval(my:lineItems, "my:Price * my:Quantity"))

However, I would like to have the order total presented in a column in our SharePoint library. I'm trying to create the same XPath in a Text Box, but am running into problems. Here is my XPath for the text box:

sum(eval(lineItems, "../my:lineItems/my:Quantity * ../my:lineItems/my:Price"))

But this results in a incorrect total - the Total keeps increasing by whatever is on line number one in the form.

How can I "promote" the order total from the form, not using an Expression Box?

Thanks,

Brian
 

Your eval has a problem, look at the XPaths:

(lineItems, "../my:lineItems/my:Quantity * ../my:lineItems/my:Price")

lineItems is the starting point, yet your multiplication XPaths step up above that node ("../") and then come back into it to always get the first row.

It should look more like:

(lineItems, "my:Quantity * my:Price")