Re: SharePoint rounds decimal doubles entered from a drop-down list

Colm Flynn — Mon, 11 Oct 2010 21:01:24 GMT

I seem to have it sussed. I think I was publishing a field in an InfoPath form that was defined as a decimal - range 0.1 to 1.0 - to a default column in SharePoint that was defined differently. SharePoint was rounding down any value in my field less than 0.5 to 0 and rounding up and value above 0.5 to 1.

I created a new column in SharePoint, configured it as a percentage, then published the same data to the new column.

SharePoint rounds decimal doubles entered from a drop-down list

Colm Flynn — Mon, 11 Oct 2010 16:55:33 GMT

Hello

I have a field in a foirm created in InfoPath 2010 where users are supposed to enter probabilty in increments of 10% from a drop-down list. The values they can chose from are defined as "decimal (double)" and range from 0.00 to 1.00. Because this is a DDL and not a text box there is no "Format" function for me to click. Once I import the data into SharePoint 2007, SharePoint rounds data to a whole number, displaying only a 1 or a 0. I also lose the ability to format this column to change how it displays this data.

Any advice would be greatly appreciated.

Newbie Questions

Re: SharePoint rounds decimal doubles entered from a drop-down list

SharePoint rounds decimal doubles entered from a drop-down list