<?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: Sumif in Infopath (Sum a field meeting a criteria)</title><link>https://www.infopathdev.com:443/forums/thread/107273.aspx</link><pubDate>Sat, 02 Jul 2016 11:59:12 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107273</guid><dc:creator>Edwin Brito</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107273.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=107273</wfw:commentRss><description>I found it!!

sum(xdMath:Eval(../my:group2/my:group3[my:Payment = &amp;quot;Personal Funds&amp;quot;], &amp;quot;my:Amount&amp;quot;))</description></item><item><title>Sumif in Infopath (Sum a field meeting a criteria)</title><link>https://www.infopathdev.com:443/forums/thread/107272.aspx</link><pubDate>Sat, 02 Jul 2016 11:41:53 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:107272</guid><dc:creator>Edwin Brito</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/107272.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=107272</wfw:commentRss><description>Hi,

I&amp;#39;m working on a Expense Report form in InfoPath, and I need to sum a field in a repeating table meeting a criteria -Déjà vu-

I need to sum the &amp;#39;Amount&amp;#39; only when the &amp;#39;Payment&amp;#39; = &amp;quot;Personal Funds&amp;quot;

Last time I had that problem, I used the Sum and Eval functions.

So far this is the formula I have:

      sum(xdMath:Eval(../my:group2/my:group3/my:Payment[. = &amp;quot;Personal Funds&amp;quot;], ../my:group2/my:group3/my:Amount))

This is the error I&amp;#39;m receiving:

      Type mismatch.
      Error occurred during a call to property or method &amp;#39;Eval&amp;#39;.

Can you guys help me come up with the right formula syntax?</description></item></channel></rss>