InfoPath Dev

 Hi, sorry noob question ..

I have a repeating table

 Quantity           Price            Total (Calculated Value)

10                      0.50             5.00
1                        0.25             5.25

How do I get a sum of the total of calculated values as if I use Sum(calculated value) I get 0.

An easy one for you InfoPath devs probably !

Appreciate any help :) 

Hi Marculos,

Kindly try this formula using and eval approach:

sum(eval(group, "my:Quantity * my:Price"))

where group is the repeating group/section.

More information can be found here.

Regards, 

 Thanks for the help .. I get an error with this formula, guess another noob issue, can anyone assist ?

Expected value type: ,

Actual value: ..
sum(eval(my:-->..<--/my:OrderDetails/my:OrderDetailsRepeating. "my:../my:OrderDetails/my:OrderDetailsRepeating/my:decPrice * my:../my:OrderDetails/my:OrderDetailsRepeating/my:intQuantity") 

I'd guess maybe this, but be sure to use the field picker to select the piece I have in bold below.

sum(eval(my:OrderDetails/my:OrderDetailsRepeating, "my:decPrice * my:intQuantity") 

 many thanks Hilary, this has done the trick !

Thanks Again !