https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/65584.aspxWed, 30 Mar 2011 08:26:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65584Jimmy0https://www.infopathdev.com:443/forums/thread/65584.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=65584<p>This expression should work:</p> <blockquote> <p>&nbsp;translate(number(<strong><u>field</u></strong>), &#39;Na&#39;, &#39;0&#39;)</p></blockquote>https://www.infopathdev.com:443/forums/thread/65583.aspxWed, 30 Mar 2011 05:07:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65583ilya.mim0https://www.infopathdev.com:443/forums/thread/65583.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=65583<p>Hi,</p> <p>I have a repeating table which contains costs. I have to calculate a total cost. I use&nbsp;sum function.</p> <p>But some rows can contain a symbol &quot;-&quot;.&nbsp;Sum function returns &quot;NAN&quot; in this case/</p> <p>Can I use some logical expression to check a value of control and return &quot;0&quot; if the value is &quot;-&quot;?</p> <p>&nbsp;</p>