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/66032.aspxTue, 19 Apr 2011 22:36:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:66032Greg Collins0https://www.infopathdev.com:443/forums/thread/66032.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=66032<p>There are no built-in statistical functions. InfoPath uses the XPath functions, plus a few of its own internal functions.</p><p>To get statistical calculations, you will need to either have a way to manually calculate those using the existing limited math features InfoPath provides, or use code to do the calculations.<br /></p>https://www.infopathdev.com:443/forums/thread/65969.aspxSun, 17 Apr 2011 17:07:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:65969anuarna_mn0https://www.infopathdev.com:443/forums/thread/65969.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=65969<p>Hi, I&#39;m completely new to Infopath so I wish to get somebody help to assist me to solve my problem regarding MS InfoPath functions that I can use to do statistical calculation automatically.<br />Let say<br />I have the following repeating table (gp_qualification_data) as per below<br /><br /><u><b>Result 1&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;Result 2 &nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;Result Range</b></u><br />X&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; A&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; X-A<br />Y&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Y-B<br />Z&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Z-C<br /><br />&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <u><b>Average</b></u>: Avg(Result_Range)<br /><br /><br />Then, my problem is<br />1. What functions or method/idea that i can use to compute the following [<i>Std Deviatio</i>n] and [<i>Repeatability</i>] field of [<i>Result_Range</i>]?<br />2. How to compute the [<i>Status</i>] field automatically base on [<i>Repeatability</i>] field when the value less than 5<br /><br /><br /><br />Thanks <br /></p>