calculated values are going haywire - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

calculated values are going haywire

Last post 01-12-2012 01:02 PM by corisan. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-12-2012 09:28 AM

    calculated values are going haywire

    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.

  • 01-12-2012 10:59 AM In reply to

    Re: calculated values are going haywire

    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.

    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

  • 01-12-2012 01:02 PM In reply to

    Re: calculated values are going haywire

    Awesome, that fixed it.

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

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