InfoPath Calculations To SharePoint

[vargas]

I have created an InfoPath quote form for our business that connects to a
SharePoint site. It rounds to the nearest dollar on the InfoPath form;
however, when it shows in SharePoint some of the calculated totals continue
out to 6-8 digits and does not round to the nearest whole number. Does
anyone have any suggestions/solutions? BTW, I am not a programmer - more of
a sales manager thrust into a problem solving role so try to be patient with
me if this is a complicated fix.

 

[Greg Collins [InfoPath MVP]]

The rounding you are seeing in InfoPath is just a visual effect. To fix this, you will need to do actual rounding (unless there is a visual rounding effect you can do within SharePoint itself).

Do you need the full set of digits to persist in your form? If so, you'll need to find a fix for SharePoint. If not, you should be able to use the round() function in the default value formula such as the following:

round(. * 100) / 100

To increase to more than 2 decimal places, add zeros.

--
Greg Collins [InfoPath MVP]
Visit http://www.InfoPathDev.com


I have created an InfoPath quote form for our business that connects to a
SharePoint site. It rounds to the nearest dollar on the InfoPath form;
however, when it shows in SharePoint some of the calculated totals continue
out to 6-8 digits and does not round to the nearest whole number. Does
anyone have any suggestions/solutions? BTW, I am not a programmer - more of
a sales manager thrust into a problem solving role so try to be patient with
me if this is a complicated fix.