InfoPath Dev

Please can sombody help, i have a very frustrating problem.

 I have created a list in sharepoint 2010 with several number fields. i have then created a calculated column to add those fields together and set it to 2 decimal places. Check on screen and it works great.

Then i have created a new blank infopath 2010 browser based form and inserted that list as a repeating table. All of the fields display fine except for the calculated column which shows with about 10 decimal places, i cannot find a way to specify 2 decimal places on this field within infopath, but should i have to? why is it not keeping the settings specified in the list?

Can any one help me with this? i just need to get it to display as 2 decimal places.

Thanks in advance :)

Try clicking on the control and opening up the properties.  Click on Format and setting the decimal dropdown there.

The format button is greyed out because it's a calculated field in a repeating table.

Bummer :(

Did you try creating a "temp" field and setting the default value to the calculated value?  Then you can format the new temp field with the proper decimal settings.  If you don't want the extra field, you can try a calculated value and see if you get the format options there.

Yeah created a temp field but as soon as I drag it into the repeating table it takes on all of the same properties as the existing field. Is it normal for a all of the properties to be greyed out on a sharepoint calculated field in a repeating table? It's the same in all of my forms that use calculated columns in sharepoint lists :(

I managed to find a work around for this....

for every calculated column in the sharepoint list i created another number field and set the correct decimal places. Then i hid these fields from the input form and created a workflow which would activate when a new item was added or existing item was changed. the workflow set the new fields value with the value from its corresponding calculated field. (Not ideal as i now have two columns displaying the same data)

i then updated my data connections in infopath to display these new fields, deleted the calculated column controls from the repeating table and put these new column controls in, in thier place.

All works and the format button is not greyed out on these new columns as they are not calculated columns so i can change the formatting.

This is probably not the best way to do it but it works. If anyone knows how to be able to format a calculated column field in infopath then i would be interested to know.

Hope this has helped someone else like me!

Great that you figured out a workaround.  Thanks for sharing!

Hi beanyjon, Instead of creating new column for each field and setting value using workflow, you can use below string funtion in calculated field... =LEFT([YourDecimalValueFormula],INT(FIND(".",[YourDecimalValueFormula])+2)) Output returns in single line of text type. It worked for me.