https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/73790.aspxWed, 11 Jan 2012 15:04:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:73790csigler0https://www.infopathdev.com:443/forums/thread/73790.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=73790That worked.&nbsp; Many many thanks!https://www.infopathdev.com:443/forums/thread/73766.aspxTue, 10 Jan 2012 21:47:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:73766Jimmy0https://www.infopathdev.com:443/forums/thread/73766.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=73766<p>It&#39;s a bit convoluted, but this formula should do the trick:</p> <p>&nbsp;&nbsp; (my:fieldA &gt; 0) * (my:fieldB div (my:fieldA + (my:fieldA = 0)))</p>https://www.infopathdev.com:443/forums/thread/73765.aspxTue, 10 Jan 2012 21:34:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:73765csigler0https://www.infopathdev.com:443/forums/thread/73765.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=73765I have a field that is a total.&nbsp; The formula should be that if FieldA &gt;0, then divide FieldB by FieldA.&nbsp;&nbsp;&nbsp;https://www.infopathdev.com:443/forums/thread/73764.aspxTue, 10 Jan 2012 21:31:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:73764Anson Hidajat0https://www.infopathdev.com:443/forums/thread/73764.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=73764<p>Hi Corrie,</p><p>There is no IF function in XPath.&nbsp;You probably&nbsp;need to use InfoPath rules to get the behavior you want.&nbsp; What exactly are you trying to do?</p>https://www.infopathdev.com:443/forums/thread/73763.aspxTue, 10 Jan 2012 21:25:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:73763csigler0https://www.infopathdev.com:443/forums/thread/73763.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=73763<p>=IF(TotRepairEst &gt; 0, &quot;TotCustomerPercent / TotRepairEst&quot;) throws an error.&nbsp; Anyone know the correct syntax for this please?</p><p>Corrie</p>