Newbie Questions

Re: drop down list contains decimal data types retreived from SharePoint List - too many decimal places

Doreen — Mon, 31 Oct 2011 17:45:25 GMT

Thanks for the feedback. I tryed this but it's not working. I am probably setting it up wrong. It had the effect of temporarily displaying a no decimal place number but it displayed the new value in addtion to the existing list, not in place of it and then it when away when another selection is made...

FYI when a selection is made from currencyField (the dropdown control), it's value is auto-filled in another field and other fields are also auto-filled. The auto-filled fields display properly with the desired two decimal places. currencyField reads from SharePoint list that also display it's values with only 2 decimal places in the list.

Per your advice I added a rule to currencyField control to set another field called extraField, to 99999.99999.

Action: set field extraField to 99999.99999

on extraField control, I added a rule as follows:

Condition: if currencyField is not blank,

Action: set field extraField to round(currencyField * 100) /100

Re: drop down list contains decimal data types retreived from SharePoint List - too many decimal places

Jimmy — Fri, 28 Oct 2011 23:10:04 GMT

One way to change a value in every row of a repeating group is to identify some field that you're not going to use, and after you query the data source, have a rule that sets that field to some improbable value, like 9898989898989. Then put any rules you want on that field to change the values of other fields in that repeating group. In this case you would add a rule to set your currency field to round(currencyField * 100) div 100. That will update the values in each row accordingly.

Makes sense?

drop down list contains decimal data types retreived from SharePoint List - too many decimal places

Doreen — Fri, 28 Oct 2011 21:56:34 GMT

I have a form (IP 2007) that retrieves currency values from a SharePoint 2007 list. The columns in SharePoint are set as currency data type with 2 decimal places. I am using a drop down control to retrieve the currency value but the number displays14 decimal places and I only want 2. How do I control the decimal places in a drop down list? There is no function in a drop down control so that I can control this. Should and can I do this through C# code behind? If so how?