<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Data Connections</title><link>https://www.infopathdev.com:443/forums/44.aspx</link><description> </description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Using a SharePoint list as an external data source for a web form</title><link>https://www.infopathdev.com:443/forums/thread/94381.aspx</link><pubDate>Tue, 19 Nov 2013 18:04:31 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:94381</guid><dc:creator>Hilary Stoupa</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/94381.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=94381</wfw:commentRss><description>&lt;p&gt;&lt;BLOCKQUOTE&gt;&lt;div&gt;&lt;img src="/Themes/infopathdev/images/icon-quote.gif"&gt; &lt;strong&gt;Jacob Sweany:&lt;/strong&gt;&lt;/div&gt;&lt;div&gt;Bypassing the calculated field method altogether and just dragged the field containing the lookup directly on the form&lt;/div&gt;&lt;/BLOCKQUOTE&gt;&amp;nbsp;&lt;/p&gt;&lt;p&gt;That would indicate to me that for some reason the data isn&amp;#39;t being returned to the form - if this field is the data field from your list connection...&lt;/p&gt;</description></item><item><title>Re: Using a SharePoint list as an external data source for a web form</title><link>https://www.infopathdev.com:443/forums/thread/94380.aspx</link><pubDate>Tue, 19 Nov 2013 17:56:23 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:94380</guid><dc:creator>Jacob Sweany</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/94380.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=94380</wfw:commentRss><description>Anyone? I&amp;#39;ve searched through the forums here and can&amp;#39;t find anything that could help with this problem.</description></item><item><title>Using a SharePoint list as an external data source for a web form</title><link>https://www.infopathdev.com:443/forums/thread/94306.aspx</link><pubDate>Thu, 14 Nov 2013 17:11:29 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:94306</guid><dc:creator>Jacob Sweany</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/94306.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&amp;PostID=94306</wfw:commentRss><description>I&amp;#39;m having an issue displaying data on an InfoPath 2013 form (hosted in a SharePoint 2013 library) which uses external data coming from a SharePoint list on the same site.

I&amp;#39;m using external data because it happens to be contract rates (which tend to change), and the data is used all over the form. I&amp;#39;ve created input fields, fields that multiply the corresponding input field by the rate (external data), and fields that calculate the totals.

The issue: the InfoPath form will work perfectly when previewed, but when I publish it to the SharePoint library and view it in the browser, rates (that rely on the external data in the SharePoint list) will not calculate, just shows &amp;quot;NaN&amp;quot;. Any other calculated values on the form will work properly, however. If I try filling the form out through SharePoint but using the InfoPath Form Filler, the rates display correctly. The issue only happens when filling the form out in the browser.

Here was my exact process in creating the calculated fields:

Created field element with the Decimal (double) data type
Added the appropriate formula in the Default Value section (includes the formulas which used the lookup data)
Dropped the field onto the form table
Right clicked on the field, changed type to Calculated Value
Applied currency formatting on the field
I used this method instead of just creating Calculated Values directly, because apparently when you do that, you will get lots of errors when publishing to SharePoint.

I have tried:

- Deleting and republishing the form library.

- Bypassing the calculated field method altogether and just dragged the field containing the lookup directly on the form, (displays no value on the web form).

- Turning off the option to store a copy of the external data in the form template.

- Converted the external data format to legacy mode and back to the current mode.

I am somewhat new to InfoPath. Maybe I&amp;#39;m doing something wrong here? Will much appreciate any insight to this issue.</description></item></channel></rss>