<?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>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: Sum of a filtered node set</title><link>https://www.infopathdev.com:443/forums/thread/6618.aspx</link><pubDate>Mon, 04 Apr 2005 11:42:13 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:6618</guid><dc:creator>Shanthi Reddy</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/6618.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=6618</wfw:commentRss><description>It looks like what you want to do is save the calculated values into the main xml file. The best way to do this would be to show the field as a read only text box and set the default value as the sum or whichever math function you want to do. You can also use Rules to set the field value and that should also work.&lt;br /&gt;&lt;br /&gt;Does this help?&lt;br /&gt;&lt;br /&gt;Shanthi&lt;br /&gt;InfoPathDev India</description></item><item><title>Sum of a filtered node set</title><link>https://www.infopathdev.com:443/forums/thread/4602.aspx</link><pubDate>Wed, 30 Mar 2005 15:03:58 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:4602</guid><dc:creator>mmattson</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/4602.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=4602</wfw:commentRss><description>I created a new thread last week and didn't receive any responses. I did some more research and maybe I can ask the question better now.&lt;br /&gt;&lt;br /&gt;I have an Access DB which contains my Leave Tracking data. The InfoPath form I am creating will be a leave request form with several fields being calculated for the user. I am allowing a user to enter a date when the leave will/has occurred. The date will be used to filter only those Pay Period records which are before the date entered. &lt;br /&gt;&lt;br /&gt;The fields in each record returned are:&lt;br /&gt;&lt;br /&gt; payPeriod (date)&lt;br /&gt; sickAvail (decimal)&lt;br /&gt; sickUsed (decimal)&lt;br /&gt;&lt;br /&gt;I want to sum the values of sickAvail &amp; sickUsed. Can I do this as simply a calculated Expression BOx or should I be using the Event Rules to set field values? Does anyone have an example, because I have not been able to get this to work yet.</description></item></channel></rss>