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/6817.aspxMon, 16 May 2005 14:12:33 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6817Fast Flare0https://www.infopathdev.com:443/forums/thread/6817.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6817Hi Patrick! I'm sending you an email with all the info. Thanks! Tracy<br /><br />Hi Tracy,<br />Cool site! What do you charge for logos?<br />:)<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDev<br /></div></BLOCKQUOTE><br /><br />T. Hunt<br />tracy@fastflare.com<br />www.fastflare.comhttps://www.infopathdev.com:443/forums/thread/6816.aspxThu, 12 May 2005 16:26:07 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6816Patrick Halstead0https://www.infopathdev.com:443/forums/thread/6816.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6816Hi Tracy,<br />Cool site! What do you charge for logos?<br />:)<br /><br />Patrick Halstead [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/6815.aspxThu, 12 May 2005 13:44:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6815Fast Flare0https://www.infopathdev.com:443/forums/thread/6815.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6815Thanks! Very helpful.....<br /><br />T. Hunt<br />tracy@fastflare.com<br />www.fastflare.comhttps://www.infopathdev.com:443/forums/thread/6814.aspxWed, 11 May 2005 17:05:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:6814Greg Collins0https://www.infopathdev.com:443/forums/thread/6814.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=6814XPath itself doesn't have an avg() function. InfoPath does have an avg() function under XDocument.Util.Math.Avg() but it requires a list. If you have a repeating group, the list is easy to obtain. Otherwise you might be able to get a list by doing a specialized select in XPath such as SelectNodes("field1 | field2 | field3 | field4").<br /><br />Another way to do this is not very complex, just brute force... simply add all four fields together and then divide by four:<br /><br />(field1 + field2 + field3 + field4) / 4.<br /><br /><br /><br />Greg Collins [InfoPath MVP]<br />InfoPathDevhttps://www.infopathdev.com:443/forums/thread/4659.aspxTue, 10 May 2005 13:33:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4659Fast Flare0https://www.infopathdev.com:443/forums/thread/4659.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4659Here's the problem:<br /><br />I have 4 text boxes that need to be averaged, and the result shown in another box. All the text boxes are decimals. I cannot seem to find the right syntax for averaging the four fields. I try using the formula button in the text box property dialog box (with the "avg" function), but I only get a sum of the numbers. Also, when I publish the form, before it's filled out, there is a "NaN" showing in the box. <br /><br />Does anyone know the correct syntax for this? Thanks.<br /><br />T. Hunt<br />www.goisc.com<br />www.fastflare.com