I am trying to get a total in infopath

[Surfs_UP]

And am about to go insane. What I want to do is get
Qty x Price = Total
=Grand Total
And though I can get it do do this once, When I try to add a line to make
the Grand total the total of the whole sheet I will only add the first line.
I have tried to get this done adding it several different ways and the worst
thing that happened is that it keeps telling me that it can not find the path
that it SHOWS ON THE DISPLAY!
If there was a way that I could have done this form that I want in another
Microsoft package I WOULD BE DONE BY NOW!!!
What dod I do??? Please someone help me.
Lost in Kansas City.

 

[Cate]

Do you have Qty, Price and total in a repeating table? If not, I think
you need to put them there. THEN put the Grand Total outside of the
repeating table and set the formula for sum(total) and you should get a
running grand total.

 

[virgul]

Hi,

Here is the answer:

sum(eval(purchase_request_item, "@quantity * @unit_price"))

eval() returns a nodeset containing the result of the expression given
in
the second argument applied to the nodeset given in the first argument.
Then, sum takes that result nodeset and computes the total.