SharePoint Integration

Re: calculated values are going haywire

corisan — Thu, 12 Jan 2012 21:02:32 GMT

Awesome, that fixed it.

I never would have thought of the postback, thank you!

Re: calculated values are going haywire

Anson Hidajat — Thu, 12 Jan 2012 18:59:14 GMT

That does sound odd! Well I have an idea you can try. For your repeating table, go into the properties and click on the Browser forms tab. Select always here. My suspicion is that the value isn't getting updated in the browser and will require a postback. I should warn you though that this might slow down the performance of the form, but its probably better than a form that doesn't work.

calculated values are going haywire

corisan — Thu, 12 Jan 2012 17:28:23 GMT

I am having a really bizarre issue with calculated values. In a repeating table, I have a text box control that contains a decimal data type. In the table footer, I've set up a calculated value function to display the sum of this column [i.e., sum(textBox) ].

In the InfoPath preview screen, the form works flawlessly. I can add and remove rows, and the calculated value field recalculates as expected.

However, since publishing to a SP 2010 forms library, the calculated values cannot seem to perform proper math functions anymore.

Any ideas?

And, just to make this more strange, the form gets submitted by email. When I open the email, all the calculated values are correct despite the random numbers that came up within the browser.