https://www.infopathdev.com:443/forums/41.aspxIf 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.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/77943.aspxTue, 24 Apr 2012 16:58:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77943Anson Hidajat0https://www.infopathdev.com:443/forums/thread/77943.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=77943<p>A date diff is not easy to do in InfoPath out of the box.&nbsp; I believe you&#39;ll need to write custom code or use <a title="qRules" href="http://www.qdabra.com/en/products/qRules_new.aspx">qRules</a> for that functionality.&nbsp; If you are just using total time then your formula will just look something like:</p><p>totalField * numUsersField * (percentField/100)</p><p>Hope this helps!</p>https://www.infopathdev.com:443/forums/thread/77884.aspxMon, 23 Apr 2012 20:50:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:77884ernestwade0https://www.infopathdev.com:443/forums/thread/77884.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=77884<p>I currently have an InfoPath 2010 form requirement which I&#39;m having problems formulating a math calculation in a Repeating Table. The layout is as follows:</p> <p>1. Start of Impact&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date &amp; Time field</p> <p>2, End of Impact&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date &amp; Time field</p> <p>3, Total Impact Time (mins)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Single line of text field</p> <p>4. Number of Users Impacted&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Single line of text field</p> <p>5.&nbsp;Percent of Impairment&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Single line of text field</p> <p>&nbsp;I would like to apply a rule with this logic:</p> <p><font size="3"><font face="Calibri"><span style="COLOR:#e46c0a;">Number of Users Impacted * Time Impaired (<i>difference between start of impact and end of impact</i>) * (Percent of Impairment/100)</span></font></font></p> <p><span style="COLOR:#984807;"><font size="3"><font face="Calibri">This formula was being used but is not working properly: <br /></font></font></span></p> <p><span style="COLOR:#984807;"></span><span style="COLOR:#e46c0a;"><font size="3"><font face="Calibri">~~=IF([CS Impact]=0,0,[Num of Users Impacted]*[xTime_Impacted]*([Percent of Impairment]/100)~~</font></font></span></p> <p><span style="COLOR:#e46c0a;"><font size="3"><font face="Calibri">Can anyone tell me how to get these results?</font></font></span></p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p>