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/75296.aspxWed, 15 Feb 2012 14:44:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75296edwinbrito0https://www.infopathdev.com:443/forums/thread/75296.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75296<p>It worked like a swiss clock!</p><p>Thanks!!</p>https://www.infopathdev.com:443/forums/thread/75284.aspxWed, 15 Feb 2012 07:36:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75284Jimmy0https://www.infopathdev.com:443/forums/thread/75284.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75284<p>Try avg((firstField | secondField | thirdField | fourthField | fifthField)[. &gt; 1])</p>https://www.infopathdev.com:443/forums/thread/75282.aspxWed, 15 Feb 2012 04:45:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:75282edwinbrito0https://www.infopathdev.com:443/forums/thread/75282.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=75282<p>Hi,</p><p>I need to calculate de average of 5 non-repeating fields. My problem is that I need to do this only if the fields have a value on it. I tried sumung all the fields and dividing the result by 5, but the average is not accurrate if one or more&nbsp;of the fileds have no value.</p><p>Field:&nbsp;&nbsp; </p><p>a = 10</p><p>b = 10</p><p>c = 10</p><p>d = 10</p><p>e = (empty)</p><p>Ave= (10 +10 +10 +10 +0) / 5 =&nbsp;<strong>8 :-(</strong></p><p>What I want to accomplish is to&nbsp;calculate the average only for the fields that are greater than 1.</p><p>Any sugestions?</p>