InfoPath Dev

Hi

I have Master/Detail form

In the repeation section i would like to do some calculations.

for instance i would like to take fields from my datasource and multiply them to get the value for another field.

So Annual Interest Rate Only = MortgagteAmount * InterestRate

When i do this i get and Invalid Data (NaN): For every calculation:

This is what i did

Right Click on AIR Field > Select Text Box Properties > Select Value (fx) > Clicked Insert Field > Select MortageAmount > add * > Clicked Insert field > Select Interest Rate

@MortagageAmount * @InterestRate

Click Verify Formula ----> The formula does not contain any errors

Close

Go to Preview

$0 shows as default

retrieve record(s)

Red Box with NaN displayed

(Note: this works if i simply mutiply by a constant (1,2,3,4,etc......) but not when i multiply by field

Example of field values

$10,0000 * 5.5 when error occurs

 

thanks in advance

I am an InfoPath newbie and it would be nice to share and learn from others. So, let me give this one a shot.    I am using IP 2007. Here are the detailed steps.  

1. I added 3 text boxes.
2. In the first text box (field1) - change the datatype = "Whole Number (interger)" and format = "Currency" with a default value to 100000.
3. In the second text box (field2) - change the datatype = "Decimals" and format = "Number" with a default value = 5.5.
4. In the third text box - change the datatype = "Whole Number (interger)" and format = "Number" and click on the fx button and insert formula = field1 * field2.
5. Verify the formula (it should work.)
6. Preview the form. You should see the value(550,000) in the third text box. 

Hope this helps!