InfoPath Dev

Currently I have a form that a user will enter a price and quantity and then it will calculate the total cost.

For the most part it works perfectly fine, but for some reason when anyone enters a price that ends in .95 the total column adds a lot of 0's after the correct total. I also have a second total that totals the totals and it calculates fine.

When I try and set my currenct from auto to 2 decimals it does show the correct total but still errors on invalid data.

Any ideas the formula I am using in the value is round((@itemPrice * @itemQuantity) * 100) * .01

 One alternative formula you could try is:

round((@itemPrice * @itemQuantity) * 100) div 100

That might give you better luck in terms of the trailing digits. Could you clarify what you mean when you say it "still errors on invalid data"? What invalid data are you referring to?

When I set to 2 decimals the same field still shows up with the red box due to invalid data, but I am not sure what  makes it invalid.

Well, what's the datatype of the field? Does it have any validation rules?