Error multiplying two fields in InfoPath repeating table

[BethB]

Multiplying these two fields seems like it should be fairly straightforward,
but I am stuck. I want to multiply field "quantity" times "unitPrice" in my
repeating table. "quantity" is a text field and "unitPrice" is also a text
field (format is Currency) that is auto-filled using a rule from another
field that looks up the value based on a SP list/Data Source. I added the
formula quantity*unitPrice and click Verify Formula in a field called
"pretaxPrice" which is also a text field. Originally formatted as string,
then changed format to Currency. I keep getting an error "quantity" does not
point to a valid location path of a field or group. If I put unitPrice first,
i get the same error except for "unitPrice" instead of "quantity". Please
advise.

 

[BethB]

OK - so I figured out the problem. In the Insert Formula dialog box I had
been simply typing my field names along with the * operator to create the
formula. Instead I had to choose the Insert Function button, select an
operator such as Sum, then modify that in the formula so that IP could
determine the fields I was using. My headache has gone away!