SharePoint rounds decimal doubles entered from a drop-down list - InfoPath Dev
in

InfoPath Dev

SharePoint rounds decimal doubles entered from a drop-down list

Last post 10-11-2010 02:01 PM by Colm Flynn. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 10-11-2010 09:55 AM

    SharePoint rounds decimal doubles entered from a drop-down list

    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.

     

    C 

  • 10-11-2010 02:01 PM In reply to

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

    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.

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.