InfoPath Dev

When In Calculate a decimal from a sum function in Infopathand it displays in the text box during run-time, it has a red dotted square around it displaying a error. The calculation is right, but why is it displaying as a error. Even when I try to publish the form to SharePoint, SharePoint will not accept the field. What can i do to get InfoPath and the SharePoint form Library to accept 98.3 or 113.4.
I've tried changing the SQL data types that still didn't work. Please help.

When red dotted square is displayed, right click on that field to find out the error. What is the error displayed?

It says that InfoPath don't accept this format. I used a varchar in my database and it worked fine, but I have .607057 and 7.657656 displayed in my form library. Is it any way I can round off in my form libray and display 0.6 and 7.6 as a percent. I already rounded off in InfoPath and chose 1 decimal, but in form library it display to many decimals.

In order to display the round off value of the decimal in form library you need to use the "round" function in InfoPath instead of formatting the field.

Enter "round(field * 100) / 100 " in the value field of text box properties window

That worked but I had to type round((@MoneySpent / @MoneyBudget) * 10000) / 100
this worked just right, execpt what if I want .04 or .14

Whatever field receives this calculation, try setting the format on the field (#.## or #.00). Check out MSDN Help for Number formatting. I, too, had an issue with decimal figures and significant digits. This seemed to fix it.

Thanks for this u made day COOL!