SharePoint Integration

Re: Getting infoPath and SharePoint to Accept a 98.3

incuboi — Wed, 07 Oct 2009 07:14:10 GMT

Thanks for this u made day COOL!

Re: Getting infoPath and SharePoint to Accept a 98.3

danielNAthens — Thu, 14 Dec 2006 14:23:42 GMT

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.

Re: Getting infoPath and SharePoint to Accept a 98.3

Michael71 — Wed, 01 Nov 2006 14:05:35 GMT

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

Re: Getting infoPath and SharePoint to Accept a 98.3

Mahitha — Tue, 31 Oct 2006 07:13:36 GMT

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

Re: Getting infoPath and SharePoint to Accept a 98.3

Michael71 — Mon, 30 Oct 2006 21:38:33 GMT

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.

Re: Getting infoPath and SharePoint to Accept a 98.3

Mahitha — Mon, 30 Oct 2006 06:01:06 GMT

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

Getting infoPath and SharePoint to Accept a 98.3

Michael71 — Fri, 27 Oct 2006 16:42:36 GMT

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.